How to get closest search results

[royyan]

I am trying to write a SQL satetment which will pull th most closest search results out from database. I use Select Top 1 ... WHere SearchString >= 'strSearchString' to get the result. It works fine when there is on one word in search. BUt once I tried to search a phrase, it gives me wrong results sometime.
Can anyone point out a better way to do a best match search? Thanks!

 

[donutman]

How do you define the best match. What do you consider a wrong result?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]