MS SQL for count of words in a series of sentences.
Need a query that counts number of occurances of the word similar to count(field). I have a db where each record has a sentence. Count(sententFiled) returns the number of sentences with a word. This is lower than the actual number of words because some words occur more than once in a sentence.