Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

SQL - how to turn a delimited string into rows of a table

I have a string like 'item 1,item 2,item 3,item 4' into rows of a table (say MyTable) so when
I

Select * From MyTable

I will get

Item 1
Item 2
Item 3
Item 4
Avatar of sventhan
sventhan
Flag of United States of America image

Avatar of tommym121

ASKER

Seventhan,

I read the article, but still not sure how to use pivot or unpivot to achieve the result.

Would you be able to show me with an example.  Thanks.
ASKER CERTIFIED SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks.  Got it.