Full Text Search not searching special character

Question

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?

Answer 1

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