查询[LIKE]SqlServer特殊字符

image

转载自:http://www.dqhxz.com/Post_572.html

如
SELECT @EmailTitle = REPLACE(@EmailTitle,'[','[[]')--1
SELECT @EmailTitle = REPLACE(@EmailTitle,'%','[%]')--2
SELECT @EmailTitle = REPLACE(@EmailTitle,'_','[_]')--3
SELECT @EmailTitle = REPLACE(@EmailTitle,'^','[^]')--4

posted @ 2010-08-19 14:58  kkun  阅读(2400)  评论(1)  编辑  收藏  举报