I have a column called data. like John Chan,Peter Chan, Wayne Chan
It is in sql server database. Most of them has five items.
I just want to split them in sql statement.
Once it is splitted. I also want to make some insert statement
such as if item 1 is 'John Chan' update column1
If item 2 is Peter Chan' update column 2
How can I execute in one sql statement?