• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

FullText Search - SQL Server

suityou01

Potty-trained
Joined
Jan 20, 2009
Messages
21,122
Likes received
773
Thanks received
222
Location
Clown World
Hello, can you help me as I am too stupid to figure this out for myself.

I want to enable FullText search on a Text column. I have added a FullText catalog, and added the column to the catalog and populated the index.
The FullText search service is running.

However I get no hits. I should point out that StopWords is off.

Soooo

If my column contains 'Attrn' and I search on CONTAINS (MyColumn,'Att') I would expect to get a hit, but I don't.

Are there any other bear traps I haven't considered?
 
Have you tried using FREETEXT instead of CONTAINS?
 
Thanks LM. I just tried that. Still nothing.

Like 'attn%' does work :frown

OK and you explicitly specified WITH STOPLIST = OFF in your code?

What version of SQL Server btw?
 
No Wildcard :confused:

You don't always need a wild card. I understand this would force a full table scan, which kind of negates the effect of going to all the trouble of creating a full text index. Contains should match on the string wherever your search string occurs.
 

Advertisers

Back
Top