sqlserver 查询字段中是否有回车等不可见字符串

判断是否有 制表符： CHAR(9)

SELECT * FROM ItemType   WHERE CHARINDEX(CHAR(9),ItemTypeName)>0;

判断是否有 回车符： CHAR(13)

SELECT * FROM ItemType   WHERE CHARINDEX(CHAR(13),ItemTypeName)>0

判断是否有 换行符： CHAR(10)

SELECT * FROM ItemType   WHERE CHARINDEX(CHAR(10),ItemTypeName)>0

--School示例数据库，测试插入数据
 
--declare @string nvarchar(255) = 'Enter' + char(13) + char(10) + 'Line'
--INSERT INTO Department(DepartmentID, Name, Budget, StartDate) VALUES(101, @string, 0, 0);

declare @rn nvarchar(255) = '%' + char(13) + char(10) + '%'
SELECT * FROM Department WHERE Name  LIKE @rn

sql查询字段值的换行及回车符

select * from 表A
 where 字段a like '%+char(13)+%'
 update 表A set 字段a= REPLACE(字段a,char(13),'') ---去除编号中的回车