Splitting a sql column

[readbanana]

I have a column in my database that has a list of keywords. sometimes the keywords are a couple of words and sometimes just one. Each keyword (can be more than one word) is separated from a comma. for example - this is my column -
hi, how are you, good, come now, why
I want to fill each textbox with a different one of these words of phrases (hi in one box, how are you in another)

[Kumar203]

you want to split those keywords and place each keyword in individual columns. Is this the exact problem.

[tesuji]

Hi,

In this thread I gave a solution on how to split strings into parts although it was for Oracle this statement also works on SQL Server and Sybase databases without changes.

But I am afraid, you will need a more sophisticate solution because the number of tags within a string you want to separate seems to vary.

-- tesu