select name, right(name,1),ascii(right(name,1)) from dbo.[user] where ascii(right(name,1)) <32
select name, left(name,1),ascii(left(name,1)) from dbo.[user] where ascii(left(name,1))<32
update dbo.[user] set name =left(name,len(name)-1) where ascii(right(name,1)) <32
update dbo.[user] set name =right(name,len(name)-1) where ascii(left(name,1))<32
|