判断是否有 制表符: 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),'') ---去除编号中的回车