Hello Everybody,

Is this possible to select a particular column in the way that select each word in each of the rows with its word count. For example, if I have a table like this:

ID Description
1 Hello World
2 Hello Buddy
3 Buddy List

I need to write a select statement that should return following result:

Word Count
Hello 2
World 1
Buddy 2
List 1

Any ideas?

Thanks.