1

I am working on SQL Server 2008. I have created full text index on a Table(Column) and I am trying to find.

SELECT * 
FROM TblName 
WHERE CONTAINS(ColName,'@#');

This is giving no results.

But I have a row in that column which contains value @# in field, so is this the default behavior of SQL Server Full Text Search, or am I doing something wrong and need to do something for this?

4

I can't verify this right now, sorry, but IIRC you have to quote special characters because SQL Server assumes @ and # are word delimiters

SELECT * FROM TblName WHERE CONTAINS(ColName,'"@#"')

Also see the SQL Server FTS Engineering team blog

  • This doesn't work on SQL SERVER 2014 – Nikola Mitev Sep 3 '15 at 7:07
  • This returns no results, and shows the warning Informational: The full-text search condition contained noise word(s). – Max Vernon Nov 6 '17 at 21:36
  • @MaxVernon: I would assume that OP had modified the noise words stackoverflow.com/questions/469516/… – gbn Nov 8 '17 at 7:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.