Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Ranking words in a column by the number of times it appears in the database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-02 : 09:11:32
Jeff writes "I would like to be able to query our database to find the top used word in a text field. An example of this, would be if you wanted to review all the subjects in a forum database. The results would be something like:

How - 56343
the - 2352
I - 23255
KitchenSink - 1

Thanks for any tips you can come up with,
Jeff"

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-07-02 : 09:43:52
Can you clarify.. Is it a "text" field or a "varchar" field ?
Go to Top of Page
   

- Advertisement -