Special Character - Plus Sign

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khris - 21 May 2008 20:01 GMT

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

Reply to this Message

Daniel Crichton - 22 May 2008 08:01 GMT

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).
[quoted text clipped - 3 lines]
> 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.

Signature

Dan

Reply to this Message