SQL Server '05: FullTextSearch Turn Case Sensitivity On and Off
Hi,
I using FTS and namely containstable with SQL Server '05. My db is set to be case insensitive, 99% of the time this is perfect, but my users would like to be able to choose to perform searches with case sensitivity turned on. Is it possible to specify it on the fly?
With regular queries you can do this to make the clause case sensitive. Can something like this be done with FTS? -
Code:
...
WHERE IsNull(fldName,'') COLLATE Latin1_General_CS_AS=IsNull(@fldName,'')
Any help would be appreciated
Al