Search Full Text Index for 'C #'

Question

I have a table (say, it has one column called colLanguage) that contains a list of skills and has the full text index defined on it. One of the entries in the table is “C #”, but when I search for “C #” (using the following SQL), I get no results.

select * from FREETEXTTABLE(tblList, colLanguage, 'c#')

Can anyone help?

Thanks To

Answer 1

, '#' - '#'. "#" , "#" . script , , "#" "#" ( script sql, , #) , , '#' '#', .

, SQL2008 fts, "" . "" . fts, , . * FREETEXTTABLE (tblList, colLanguage, '#', LANGUAGE 0), '#' '#' - * .

* " " , .

Answer 2

, # " " . , :

http://msdn.microsoft.com/en-us/library/dd207002.aspx