请教怎么用like模糊查询出回车和换行? 急

请教怎么用like模糊查询出回车和换行? 急
[22 byte] By [javahp-小梦朗] at [2008-4-9]
# 1
declare @t table(s varchar(10),id int identity(1,1))
insert @t(s) select char(10)
insert @t(s) select 'xyz'
insert @t(s) select char(13)

select * from @t where
s like '%' + char(10) + '%' /*换行符*/
or
s like '%' + char(13) + '%' /*回车符*/
hellowork-一两清风 at 2007-10-22 > top of Msdn China Tech,MS-SQL Server,应用实例...
# 2
直接在%%之间回车就行。
achongsky-灵魂 at 2007-10-22 > top of Msdn China Tech,MS-SQL Server,应用实例...
# 3
like '%'+char(13)+char(10)+'%'
回车+换行
achongsky-灵魂 at 2007-10-22 > top of Msdn China Tech,MS-SQL Server,应用实例...
# 4
like '%'+char(13)+char(10)+'%'
dawugui-潇洒老乌龟 at 2007-10-22 > top of Msdn China Tech,MS-SQL Server,应用实例...