Convert like queries to Full Text Search

[rtgordon]

How do I convert a query with a where clause like this:

WHERE column LIKE '%xyz%'
AND column LIKE '%123%'

into a full text search query assuming everything is configured and all catalogs are created on the proper fields?

Thanks,
Gordon

 

[philhege]

Check out the CONTAINS function in Books On-Line.

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
In one hundred years, none of this will matter. Keep a healthy perspective!

 

[rtgordon]

Sorry, I specifically meant leading AND trailing wildcards... I can't see that there is a way to do this with CONTAINS in BOL.

For example, I have a xyz-123 in the field I am searching. I want it to return this row if the user enters "xyz 123" as search criteria.

I can't seem to write a FTS query that will work like this.

Am I missing something?