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?

0

1 Answer 1

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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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