查询[LIKE]SqlServer特殊字符

http://www.dqhxz.com/Post_572.html 如 SELECT @EmailTitle = REPLACE(@EmailTitle,' [ ',' [[] ') --1 SELECT @EmailTitle = REPLACE(@EmailTitle,' % ',' [%] ') --2 SELECT @EmailTitle = REPLACE(@EmailTitle,' _ ',' [_] ') --3 SELECT @EmailTitle =

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