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)
readbanana
0
Newbie Poster
Recommended Answers
Jump to PostHi,
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 …
All 2 Replies
Kumar203
0
Newbie Poster
you want to split those keywords and place each keyword in individual columns. Is this the exact problem.
tesuji
135
Master Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.