Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-01 : 09:07:14
|
| Igor writes "Hi,After reading your FAQs and the manuals, I am still stuck on a parsing issue. I hope you can help me out.Win2K Advanced Server SP1, SQL Server 2000 SP1I need to build a View that selects two columns from a table and parses one column into 4 columns. Table: Customer, Columns: Name, Description. The Description field holds 4 pieces of data separated by ";". Example: Description stores adrs1;adrs2;city3;state4 I need the output to be five columns in the view. View columns will be Name, Adrs1, Adrs2, City, State. I am stuck and cannot figure this out. Can you point me in the right direction.Thanks,Igor" |
|
|
|
|
|
Parsing Strings