If the answer to the below is already posted... please point me to the
Inside a table, I need to store text in RTF(Rich Text Format) and take
advantage of full text indexing. I would like the search engine to use
the "\" character as a delimiter in the same manner as it uses the
"."character. For example, if you have a column that is using Full
Text Indexing in SQL Server 2000 and the string in said column is
"Rich Text.", when you do a search using the string "Rich Text" you
will get a hit for the EXACT word search. The search engine knows
that the period is not part of the last word. Now, if I want to store
the data in RTF it looks something like this "\ul\b rich
text\ulnone\b0", if you search the field using the string "Rich Text"
you will NOT get a hit on the EXACT phrase "rich text" unless you
include the wild card "*" on the end of the search string. Finally my
question. Does anybody know how to configure the search engine or
full text indexing so that the "\" character will be used the same way
as a white space or the "." character?
I appreciate any helpful responses.