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)
 Ordering by occurrence of a searchstring

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-04 : 00:57:54
Benjamin writes "OK, Im stumped...

I want to do a query on 3 (or more) columns to search for the existence of a specific word BUT I want to order the results by the amount of times that specfic word occurs in that row.

and if that's possible, I want to be able to do it on a number of words....

and without the use of Microsoft Search Service.

any ideas??"
   

- Advertisement -