brgdotnet
asked on
How to parse a line of text in Sql
I need to parse a word out of a column of text, and then print out the number of times it occurs. Can someone show me how to do that in SQL?
Example:
Id Text
1 Today is a happy day because the weather is happy
2 be happy
3 be happy because when you are not happy you will be un happy, so be happy
So the sql query I need would print out the following. Can someone show me how to do that?
Id TimesOccurred
1 2
2 1
3 4
Example:
Id Text
1 Today is a happy day because the weather is happy
2 be happy
3 be happy because when you are not happy you will be un happy, so be happy
So the sql query I need would print out the following. Can someone show me how to do that?
Id TimesOccurred
1 2
2 1
3 4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.