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 2008 Forums
 Transact-SQL (2008)
 Full Text and Phrases

Author  Topic 

timgaunt
Posting Yak Master

115 Posts

Posted - 2010-02-25 : 11:41:05
Hi,

We have an issue in that we need to offer users a general search box (similar to Google) where the user can type in a key word, set of keywords or an "exact phrase" (using quotes).

I've seen that 2008 has changed the way it works [1] so I was wondering if there's an alternative or should I search for " and replace use CONTAINSTABLE and FREETEXTTABLE accordingly?

Thanks in advance

Tim
[1]http://social.msdn.microsoft.com/Forums/en/sqlsearch/thread/95922ae3-91ad-4524-b1be-6e987656edee
----------------------------
I've finally started blogging (all be it badly!)

Check it out:
http://blogs.thesitedoctor.co.uk/tim/
   

- Advertisement -