FullText Search - SQL Server

[LondonManc]

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).

[MrMarkyMark]

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

ah.....gotcha

I should add though I was explicitly talking about eh Like search string he posted.

[suityou01]

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

Like '%attrn'

works

[MrMarkyMark]

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

I did actually mean

Like '%attrn'

works

OK, but may be worth considering LMs comment..

[LondonManc]

I did do the following

ALTER FULLTEXT INDEX ON MyFullTextTable SET STOPLIST = OFF

Edit : 2012

Run this and see if it works after that:

ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION

[suityou01]

Run this and see if it works after that:

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.

[suityou01]

OK, but may be worth considering LMs comment..

I believe in either case LM is saying we are expecting a hit.

Eg 'Attn' is contained in the string 'Attrn'

[LondonManc]

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.

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

[suityou01]

Ah okay, so you've already got one.

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

e.g.

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

Yes, and this works.

[LondonManc]

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?