【问】商品存在异常字符，如何修改？
【适用版本】商云8	【模块】基本档案	【点击数】65
【知识编号】P2017121100008
【问题描述】检测到商品存在异常字符，需清除

【答】 请备份数据库后执行以下语句：
–处理货号有制表符tab
update t_bd_item_info set item_no = replace(item_no,char(9),”)
where charindex(char(9),item_no) > 0
go
–处理货号有换行 
update t_bd_item_info set item_no = replace(item_no,char(10),”)
where charindex(char(10),item_no) > 0
go
–处理货号有回车 
update t_bd_item_info set item_no = replace(item_no,char(13),”)
where charindex(char(13),item_no) > 0
goupdate t_bd_item_info set item_no = REPLACE(item_name,’（’,”) where item_no like ‘%（%’
update t_bd_item_info set item_no = REPLACE(item_name,’）’,”) where item_no like ‘%）%’
update t_bd_item_info set item_no = REPLACE(item_name,’#’,”) where item_no like ‘%#%’
update t_bd_item_info set item_no = REPLACE(item_name,’！’,”) where item_no like ‘%！%’
update t_bd_item_info set item_no = REPLACE(item_name,’@’,”) where item_no like ‘%@%’update t_bd_item_info set item_name = REPLACE(item_name,’（’,”) where item_name like ‘%（%’
update t_bd_item_info set item_name = REPLACE(item_name,’）’,”) where item_name like ‘%）%’
update t_bd_item_info set item_name = REPLACE(item_name,’#’,”) where item_name like ‘%#%’
update t_bd_item_info set item_name = REPLACE(item_name,’！’,”) where item_name like ‘%！%’
update t_bd_item_info set item_name = REPLACE(item_name,’@’,”) where item_name like ‘%@%’