开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜