print 'aa'+char(13)+'b' print 'aa'+char(10)+'b'所以: select * from table1 where 列 like '%'+char(13)+'%'
char(13)代表回车键select * from 你的表 where charindex(char(13),列名)>0如果你要查询换行,就要用回车换行. char(13)+char(10)select * from 你的表 where charindex(char(13)+char(10),列名)>0
用char(13)select * from tableName where charindex(char(13),colName)>0or select * from tableName where colName like '%'+char(13)+'%'or select * from tableName where patindex('%'+char(13)+'%',colName)>0
print 'aa'+char(10)+'b'所以:
select * from table1 where 列 like '%'+char(13)+'%'
char(13)+char(10)select * from 你的表 where charindex(char(13)+char(10),列名)>0