Escape wildcard (*) in SQL Server Contains function
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开发者_JAVA百科, any solution can only use full-text functions as the column I'm searching is an image/blob column.
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 SQL Server Full Text Search Escape Characters?
精彩评论