SQL Server Full-Text Search - Wild Card Search in Full text search

Author

Wild Card Search in Full text search

Sathian

2005-06-22, 9:23 am

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

Daniel Crichton

2005-06-22, 11:23 am

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

Hilary Cotter

2005-06-22, 11:23 am

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

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

--
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
"Sathian" <sathian.t@in.bosch.com> wrote in message
news:d9bt6n$9a3$1@ns
2.fe.internet.bosch.com...
> 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
>
>
>
>

Sponsored Links