- Joined
- Jan 20, 2009
- Messages
- 21,122
- Likes received
- 773
- Thanks received
- 222
- Location
- Clown World
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?
Your summary is perfectly correct.
I tried dropping the index and the catalog and re-creating using the GUI. Still no joy.


