Using wilcards in a fulltext index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kforem@hotmail.co.uk - 28 Jun 2006 08:54 GMT

Hello,

I have a fulltext indexed column which contains some like:

Section 0 Name
Section 1 Name

When I run a query like:

select *
from tbl_FullTextData
where contains(name,'"section 0"')

It returns records, but when I run:

select *
from tbl_Schemenamesearch
where contains(name,'"section 0*"')

It does not return anything. Not sure why this is happening.

Reply to this Message

kforem@hotmail.co.uk - 28 Jun 2006 09:38 GMT

> Hello,
>
[quoted text clipped - 16 lines]
>
> It does not return anything. Not sure why this is happening.

Have found the answer:

Need to put a space after the wildcard e.g.:

select *
from tbl_Schemenamesearch
where contains(name,'"section 0* "')

Reply to this Message

Hilary Cotter - 28 Jun 2006 12:10 GMT

Note that all terms in your search argument will be wildcarded - 0 and
section.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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 - 24 lines]
> from tbl_Schemenamesearch
> where contains(name,'"section 0* "')

Reply to this Message