Full Text Search not searching special character 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?
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