How to do SQL Server CONTAINS full text search for 'C #'

In SQL Server 2008 R2, I am doing a full text search for the term "C #" like this:

FROM  Book b  
WHERE CONTAINS (b.title , 'c#')


However, a full text search looks like it strips out the pound sign and then does the search.

If I do the "as" wildcard, I get the correct results:

FROM  Book b  
where title like '%c#%'


Is there a way to do a full text search CONTAINS

for an expression that contains a hash / pound sign?


source to share

2 answers

It looks like full text search does exactly what it was supposed to do. To match exactly, modify the where clause C#

to enclose the term in double quotes. Since exact matching is case sensitive by definition, you can use or to search in both lowercase and uppercase versions.

WHERE CONTAINS(Name, '"C#" or "c#"');




I don't have a sandbox to test this, but have you tried CHAR(35)

which is the pound icon? You can set a variable and concatenate it with CHAR(35)

that may work.



All Articles