Re: Special Character - Plus Sign

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Khris wrote on Wed, 21 May 2008 12:01:01 -0700:

I understand from other posts that special characters should be
converted into words (example % should be changed to percent).
I am trying to work with a plus sign (example find product names like
33+)
I tried changing the + to plus (and to "append" and to "add") but
nothing seems to work.
NOTE - using SQL 2005.

Thanks in Advance


Special characters are not converted into words by FTS - you have to do this
yourself in the actual data. For instance, you create your application to
change all occurrences of + to the word PLUS when the data is inserted, and
in your search code you change all occurrences of + to the word PLUS before
passing to FTS, and you will get matching results because the query matches
the data.

--
Dan


.