how to do suffix search on full text indexed table

anandcse17 2014-05-20 08:40:44

How to query a full text table like "like" operator?
Suffix search is not fetching the result…
i am using contains and searching in all the columns.Can you please help , how to do suffix search on full text indexed table
SQLkiwi 2014-05-20 09:07:26
Full-text search only supports prefix search. In some circumstances, reversing the string, indexing that, and then searching for the reverse of the suffix can be made to work reasonably well. Fundamentally, though, FTS is not designed for the purpose you require.
anandcse17 2014-05-20 09:23:03
Thank you.But is there any way to search like operator on full text indexed table
SQLkiwi 2014-05-22 07:26:40
Not generally, no. That's not what FTS was designed for, as I said.