Maybe a Quick removal of stoplist words from your search string before matching?
stoplist = "a, an, and, are, as, at, be, but, by, for, if, in, into, is, it, no, not, of, on, or, s, such, t, that, the, their, then, there, these, they, this, to, was, will, with" On Thu, Apr 3, 2008 at 6:56 AM, James Smith <[EMAIL PROTECTED]> wrote: > Does any one know how to use MSSQL's SOUNDEX() functionality to get > good search results? > > Lets say I am doing a product search by title, if the title in the DB > is "Blade Runner (DVD)" and someone searches for "Blade Runner" then > > WHERE SOUNDEX(title) = SOUNDEX(#form.title#) > > will work just fine but if someone searched for "the blade runner" > then the query would fail since SOUNDEX() only works on the first > word. > > -- > Jay > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
