ansaurus

Question

SQL Server Full Text Search Special character issue

Answer 1

A:

Since I am not sure if there exists any special function for your needs, I'd use REPLACE function:

SELECT text
FROM   tablename
WHERE  REPLACE(text, '''', '') LIKE '%Bolivias History%'

In order to ignore more special characters (like ") call multiple REPLACE functions:

SELECT text
FROM   tablename
WHERE REPLACE(REPLACE(text, '''',''), '"', '') LIKE '%Bolivias History%'

Bar 2010-05-12 15:50:57

but you are talking about in the case of "Bolivia's History" which is not a issue for me, because it gets me what I want, the issue is with the "Bolivias History", this text is similar to the "Bolivia's History", but could not return anything when I perform a search....

ManojTrek 2010-05-12 17:20:29

How can I use the replace in CONTAINSTABLE ?, any suggestion....

ManojTrek 2010-05-12 18:01:26

@ManojTrek Sorry, I was wrong about `'\''` sign in query. Have a look on the modified query, please.

Bar 2010-05-12 18:53:16

That I figure out, but still I have to use this within the CONTAINSTABLE, not sure How can I achieve this.....

ManojTrek 2010-05-12 19:03:23

@ManojTrek sorry, not familiar with `CONTAINSTABLE` yet. Ask that as a separate question.

Bar 2010-05-12 19:45:57

ansaurus

tags:

views:

answers:

SQL Server Full Text Search Special character issue

related questions