sql 特殊字符替换

 

--看ASCII码
print ASCII('a')

--tab 9  回车13  换行10  空格32  ' " , : ; . 
update Inventoty set name=replace(name,char(9),'') 
update Inventoty set name=replace(name,char(10),'') 
update Inventoty set name=replace(name,char(13),'') 
update Inventoty set name=replace(name,char(32),'')
update Inventoty set name=replace(name,'''','')
update Inventoty set name=replace(name,'"','')
update Inventoty set name=replace(name,',','')
update Inventoty set name=replace(name,':','')
update Inventoty set name=replace(name,';','')
update Inventoty set name=replace(name,'.','')