正则吧 http://topic.csdn.net/u/20120330/11/30393dc4-dd30-48db-a3f3-d398f908ccf0.htmlsql很麻烦,列举出所有你认为不应该出现在首尾的字符。declare @str varchar(100) = ' a cd 'declare @pos int = patindex('%[^'+char(9)+char(10)+char(13)+' ]%', @str) if (@pos>1) set @str = stuff(@str,1,@pos-1,'')set @str = reverse(@str) set @pos = patindex('%[^'+char(9)+char(10)+char(13)+' ]%', @str) if (@pos>1) set @str = stuff(@str,1,@pos-1,'')set @str = reverse(@str)select '|'+@str+'|'
http://topic.csdn.net/u/20120330/11/30393dc4-dd30-48db-a3f3-d398f908ccf0.htmlsql很麻烦,列举出所有你认为不应该出现在首尾的字符。declare @str varchar(100) = ' a cd 'declare @pos int = patindex('%[^'+char(9)+char(10)+char(13)+' ]%', @str)
if (@pos>1) set @str = stuff(@str,1,@pos-1,'')set @str = reverse(@str)
set @pos = patindex('%[^'+char(9)+char(10)+char(13)+' ]%', @str)
if (@pos>1) set @str = stuff(@str,1,@pos-1,'')set @str = reverse(@str)select '|'+@str+'|'
declare @str varchar(50)
SELECT @STR=' !#$@%$#^%ABC123'
SELECT @STR,STUFF(@STR,1,PATINDEX('%[0-9A-Za-z.]%',@STR)-1,'')
执行结果:
!#$@%$#^%ABC123 ABC123