Is there a way to escape the * character in a full text Contains function in sql server 2008? I've tried a standard escape by using square brackets, but that just throws a syntax error. Also, any solution can only use full-text functions as the column I'm searching is an image/blob column.
+1
A:
There is no point in escaping and searching for special characters such as * because they are treated like word separators and are not indexed. Fulltext indexes do not support searching for them.
See also related question http://stackoverflow.com/questions/995478/sql-server-full-text-search-escape-characters
marapet
2010-07-11 21:33:22
I was afraid of that - thanks
jlnorsworthy
2010-07-11 23:29:40