Why, I still didn't get an answer from the poster in this post.
But with Rudy laying the ground work I came up with the following.
Why anyone would need to do thids, I have no idea. I added a twist to this version
where it counts the occurances. The end goal here though was to find the text
row with the most occurances of any 1 word, and order the rows in that order.
Why? I have no idea.
create table somewords( id integer not null primary key identity, blah text not null);insert into somewords (blah) values ('a word...