Wild Card Search in Full text search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sathian - 22 Jun 2005 15:39 GMT

Hello ,

Is there a way to implement wildcard search like using LIKE operator to
implement in FullText Search using FREETEXT or CONTAINS?
For example Giving a key word, 'Mexico' should fetch the records which
contains 'Mexicocity'

Thanks in advance.

Regards

Sathian

Reply to this Message

Daniel Crichton - 22 Jun 2005 16:15 GMT

Sathian wrote on Wed, 22 Jun 2005 20:09:16 +0530:

> Is there a way to implement wildcard search like using LIKE operator to
> implement in FullText Search using FREETEXT or CONTAINS?
> For example Giving a key word, 'Mexico' should fetch the records which
> contains 'Mexicocity'

Check BOL. You can use "Mexico*" (the double quotes are required) to search
for all words starting with Mexico. eg.

CONTAINS(*,'"Mexico*"')

Dan

Reply to this Message

Hilary Cotter - 22 Jun 2005 16:19 GMT

Try the * after your search term, i.e.

select * from tablename where contains(columnname,':Mexico*"')

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hello ,
>
[quoted text clipped - 8 lines]
>
> Sathian

Reply to this Message