![image image](https://images.cnblogs.com/cnblogs_com/kkun/WindowsLiveWriter/LIKESqlServer_D38B/image_thumb_1.png)
转载自: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