Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Full-Text Search - Allow special characters

Author  Topic  malwah Starting Member 1 Post Posted - 2013-03-21 : 05:42:41 If this is possible, how do I config or write a query that can search for special characters like & - %. Data in table: Id Name 1 Claes & Petersson 2 Claes - Petersson 3 Claes Petersson 4 Claes Petersson If I want to have the result: Claes & Petersson SQL?: select name from person where contains(name, '?')