sql2005模糊查询

[chai1338]

我要根据3个条件进行模糊查询，如下：
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER proc [dbo].[GetListGoodBySelect]
@size varchar(50),
@type varchar(50),
@load varchar(50)
as
select * from ListGoods where [size] like '%'+@size+'%' or [type]like '%'+@type+'%' or [load]like '%'+@load+'%'

如果参数为空 则该条件不存在，我调试了下 貌似全部为null的话什么都查不出来。与我要的结果完全相反。哪里出了问题

[pt1314917]

ALTER proc [dbo].[GetListGoodBySelect]
@size varchar(50),
@type varchar(50),
@load varchar(50)
as
select * from ListGoods where [size] like '%'+isnull(@size,'')+'%' or [type]like '%'+isnull(@type,'')+'%' or [load]like '%'+isnull(@load,'')+'%'

[jiangshun]

select * from ListGoods 
where ([size] like '%'+@size+'%' or @size is null) 
     or ([type] like '%'+@type+'%' or @type is null) 
     or ([load] like '%'+@load+'%' or @load is null)

[dawugui]

isnull('%'+@size+'%' , '一个不可能存在的值')