制表符 CHAR(9)
换行符 CHAR(10)
回车 CHAR(13)
select a,b from table where notes like '%'+char(13)+'%'
or notes like '%'+char(10)+'%'
or notes like '%'+char(9)+'%'
order by nspdate desc
SELECT *, REPLACE(detail, CHAR(13) , '
') AS 显示替换后的内容 FROM Test
SET detail = REPLACE(detail, CHAR(13) + CHAR(10), '
')
阅读(1809) | 评论(0) | 转发(0) |
