InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 19:38:00 GMT20http://www.sqlservercentral.com/Forums/Topic797418-391-1.aspxThanks Lowell for the link. It is very helpful. I couldn't understand completely his code,but what helped me was to look into SQL Server 2008 Full Text Indexing option, which has already been available in earlier versions, but I totally forgot about it. Thanks again.Sat, 03 Oct 2009 20:48:16 GMTsqlbluehttp://www.sqlservercentral.com/Forums/Topic797418-391-1.aspxthere's a great article here on SSC on [url=http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/]creating a google like full text search[/url], which does everything you are asking and more; I'd suggest going that way first, as it would make your searches much more robust and professional.Sat, 03 Oct 2009 13:04:22 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic797418-391-1.aspxHi, I need help in getting the result back from the search based on the criteria as follow:1) if the user type in the text box the words 'rest again' without any quotes around them (the single quotes I put around them here just to differentiate them from the rest), the result should come back as rest OR again OR resting is fine. But nothing should come back that stand before the word rest (so, antirest and anti-rest should not comeback from the result). 2) if the user type "rest again" in the box (with the double quotes around them as shown) , the result should come back as the whole 2 words 'rest again' (again, the single quote i put around them here just to differentiate fromthe rest). Any idea would be appreciated. the sample is below. create table test( id int not null, string varchar(100) NULL)GOinsert into testselect 1, 'rest' unionselect 2, 'resting experience'unionselect 3, 'rest again'union select 4, 'anti-rest'union select 5, 'antirest'GOcreate procedure proc_test( @string varchar(100) )asselect * from testwhere string LIKE '% ' + @string + ' %' OR string LIKE ' ' + @string + '%' OR string LIKE @string + '%' --drop table test --drop procedure proc_test Sat, 03 Oct 2009 11:56:28 GMTsqlblue