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?