I have a full text CONTAINS query on a nvarchar column and it does not return any result when the search criteria contains a forward slash "/".
SELECT * FROM Product WHERE CONTAINS (Description, '5/8')
The description I'm expecting to match is 'Adapter 5/8 inch'
To ignore stop words, I have run the below code (code details in the code section below) on the database. This worked for ignoring stop words that were numbers.
Microsoft SQL Server Standard Edition (64-bit) SP1
Version: 2008 R2, (10.0.2531.0)
on Windows Server 2008 - Standard - SP2.
sp_configure 'show advanced options', 1
sp_configure 'transform noise words', 1