sql模糊查询条件问题

[hgqxz]

我要按 Name ,TANO ,Fdate ,Edate做模糊查询
请问这个where怎么写啊.我写的老是查不出我想要的结果
下面上是我写的存储过程
CREATE Procedure Plant_FIN_TA_GetViewByTANO(
@TANO nvarchar(50),
@User nvarchar(50),
@Fdate nvarchar(50),
@Edate nvarchar(50)
)
as
select AppDate, Name,Data,User,Status,TANO,Department,Amount from worklist
where
Name like '%'+@User+'%'
or TANO like '%'+@TANO +'%'
and (AppDate>=@Fdate and AppDate<=@Edate)

[-狙击手-]

CREATE         Procedure   Plant_FIN_TA_GetViewByTANO( 
@TANO   nvarchar(50), 
@User   nvarchar(50), 
@Fdate   nvarchar(50), 
@Edate   nvarchar(50) 
) 
as 
exec('select   AppDate,   Name,Data,User,Status,TANO,Department,Amount   from   worklist   
where 
  Name   like   ''%'''+@User+'''%'' 
or     TANO   like   ''%'''+@TANO   +'''%'' 
and AppDate between '''+@Fdate +'''  and '''+ @Edate+'''') 

[tim_spac]

CREATE Procedure Plant_FIN_TA_GetViewByTANO(
  @TANO   nvarchar(50),
  @User   nvarchar(50),
  @Fdate  nvarchar(50),
  @Edate  nvarchar(50)
)
as
select
   AppDate
  ,Name
  ,Data
  ,User
  ,Status
  ,TANO
  ,Department
  ,Amount   
from   worklist  
where 1=1
and (@User = '' or Name like '%'+@User+'%')
and (@TANO = '' or TANO like '%'+@TANO+'%'）
and (@Fdate = '' or AppDate >= @Fdate)
and (@Edate = '' or AppDate <= @Edate) 

[-狙击手-]

CREATE         Procedure   Plant_FIN_TA_GetViewByTANO( 
@TANO   nvarchar(50), 
@User   nvarchar(50), 
@Fdate   nvarchar(50), 
@Edate   nvarchar(50) 
) 
as 
exec('select   AppDate,   Name,Data,User,Status,TANO,Department,Amount   from   worklist   
where 
  Name   like   ''%'+@User+'%'' 
or     TANO   like   ''%'+@TANO   +'%'' 
and AppDate between '''+@Fdate +'''  and '''+ @Edate+'''') 

go

[tim_spac]

增加Null容错

CREATE Procedure Plant_FIN_TA_GetViewByTANO ( 
  @TANO nvarchar(50)
 ,@User nvarchar(50)
 ,@Fdate nvarchar(50)
 ,@Edate nvarchar(50) 
) as 
select
   AppDate
  ,Name
  ,Data
  ,User
  ,Status
  ,TANO
  ,Department
  ,Amount 
from worklist 
where 1=1 
and (isnull(@User,'') = '' or Name like '%'+@User+'%') 
and (isnull(@TANO,'') = '' or TANO like '%'+@TANO+'%'） 
and (isnull(@Fdate,'') = '' or AppDate >= @Fdate) 
and (isnull(@Edate,'') = '' or AppDate <= @Edate) 

[pt1314917]

CREATE         Procedure   Plant_FIN_TA_GetViewByTANO 
  @TANO   nvarchar(50),
  @User   nvarchar(50),
  @Fdate  nvarchar(50),
  @Edate  nvarchar(50)
as 
exec('select  AppDate,Name,Data,User,Status,TANO,Department,Amount   from   worklist   
where (Name like ''%'+@User+'%'' or     TANO   like   ''%'+ @TANO + '%'') 
and   AppDate between '+ @Fdate +' and  '+ @Edate)