• 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

Why would it???

% just looks for Unknowns at the end of your string?

The "r" isn't at the end..

Att with CONTAINS or FREETEXT should turn up the row where a correctly indexed column contains Att (no wildcards needed).
 
Att with CONTAINS or FREETEXT should turn up the row where a correctly indexed column contains Att (no wildcards needed).

ah.....gotcha :happy

I should add though I was explicitly talking about eh Like search string he posted.
 
Why would it???

% just looks for Unknowns at the end of your string?

The "r" isn't at the end..

In the process of coding, and then popping back here to answer queries, I made a mistake.

I did actually mean
Code:
Like '%attrn'
works
 
I did do the following

Code:
ALTER FULLTEXT INDEX ON MyFullTextTable SET STOPLIST = OFF

Edit : 2012

Run this and see if it works after that:
Code:
ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION
 
Run this and see if it works after that:
Code:
ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION

Thank you LM.

I tried and got this.

Warning: Request to start a full-text index population on table or indexed view MyFullTextTable' is ignored because a population is currently active for this table or indexed view.
 
Thank you LM.

I tried and got this.

Ah okay, so you've already got one.

Have you used CHARINDEX to see what rows contain 'Att'?

e.g.

Code:
SELECT TOP 20 * FROM MyFullTextTable 
WHERE CHARINDEX('Att', TextColumn) >0
 
Ah okay, so you've already got one.

Have you used CHARINDEX to see what rows contain 'Att'?

e.g.

Code:
SELECT TOP 20 * FROM MyFullTextTable 
WHERE CHARINDEX('Att', TextColumn) >0

Yes, and this works.
 
In summary then, CONTAINS(YourColumn,'Att') doesn't work but CHARINDEX('Att', Yourcolumn) >0 gets results?

You've created the full-text catalog?

You've created the full-text index on the table and correctly associated it with the catalog above?

Have you tried doing it by using the wizard in SSMS?
 

Advertisers

Back
Top