SQL Server 2005 full-text search - can I search for characters with a forward slash?

Question

I am trying to use SQL Server 2005 full-text search to find single forward slash characters in an indexed column without success.

Can someone tell me if this is possible at all? Example:

In my CentralSearchCache table, the SearchData column contains a row with the text "This / string / contains / forward / slashes".

This request:

 SELECT * FROM FREETEXTTABLE(CentralSearchCache, SearchData, 'forward/slashes') 

returns data, while this query:

 SELECT * FROM FREETEXTTABLE(CentralSearchCache, SearchData, '/') 

returns nothing. Is there a way to find strings containing one or more forward slashes?

Many thanks.

Answer 1

Most likely NOT. Full TEXT search for TEXT. It is impossible to find text delimiters and even certain words that "kill words" (for example, "in", "on", etc.) that occur too often and that every non-trivial text will have anyway).

Otherwise, the "/" question is filtered out, a bit, I would somehow put it.