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 |
|
agenda9533
Starting Member
16 Posts |
 Posted - 2005-06-30 : 11:07:58
|
| I have a table that has a "Problem" field with the following dataCustomer Service...Jam...Jam 5...Planned Technical Support...WinOnCD...WinOnCD6PowerEdition...Request...Reporting New Drive Sale MadeI need to separate this "Problem" field into separate fields the issue1, issue2, issue3, issue4 and issue5 .What would be the easiest way to do so within the SELECT statement ?Thank you! |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-06-30 : 11:11:21
|
is there some kind of delimter? could you give us a little more detail?Corey Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."  |
 |
|
|
agenda9533
Starting Member
16 Posts |
Posted - 2005-06-30 : 11:14:07
|
| Yes, '...' seems to be delimeter. |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-06-30 : 12:57:34
|
search the forums for getCsvPart... i'm sure this has been done before  CoreyCo-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now." |
|
|
|
agenda9533
Starting Member
16 Posts |
Posted - 2005-06-30 : 12:59:15
|
| THANK YOU! |
|
|
|
|
|
|
Parse the string