【SQL Server】SQL查询和替换含有回车，空格，TAB

---如下是查询语句 
--查询名称有退格键 
select * from t_bd_item_info  where charindex(char(8),item_name) > 0  
go 


--查询名称有制表符tab  
select * from t_bd_item_info  where charindex(char(9),item_name) > 0  
go 
--查询名称有换行   
select * from t_bd_item_info where charindex(char(10),item_name) > 0  
go 
--查询名称有回车   
select * from t_bd_item_info where charindex(char(13),item_name) > 0  
go 
--查询名称的空格（前空格、后空格、所有空格） 
select * from t_bd_item_info where isnull(charindex(' ',item_name),0) > 0    
go 
--查询名称的单引号  
select * from t_bd_item_info where charindex(char(39),item_name) > 0  
go 
--查询名称的双单引号  
select * from t_bd_item_info where charindex(char(34),item_name) > 0  
go 




--处理名称有退格键 
update t_bd_item_info set item_name = replace(item_name,char(8),'')  
where charindex(char(9),item_n