|
Kristen Baker-Munton
Starting Member
United Kingdom
1 Posts |
 Posted - 31 January 2004 : 07:41:01
|
| Don't know if you are still stuck with this, but one answer might be to use a "delimiter split" on the text (splitting on [any of] SPACE, "-", ".", "," etc.) - that would create a complete list of all words in, say, a temporary table and then do your COUNT from there. I've got some code lying around for a SQL FUNCTION that does a delim-split, shout if it sounds like a runner. You'd probably have to use a cursor to process all the records, and if they are TEXT, rather than VARCHAR, that would add to the pain. (Assuming that not TOO many rows match "WHERE [MyText] LIKE '%hello%'" then the cursor won't be horribly slow) |
Kristen |
 |
|
Topic Locked
