求语句合并经典写法,有答案,马上结帐送分
declare @message varchar(50)
set @message = '0755 '
--左模糊匹配
select * from AutoReply_DestCodeFilter where left(DestCode,Len(@message)) = @message and FetchMethod = 1
--右模糊匹配
select * from AutoReply_DestCodeFilter where Right(DestCode,Len(@message)) = @message and FetchMethod = 2
--任意匹配
select * from AutoReply_DestCodeFilter where DestCode like '%0755% ' and FetchMethod = 3
能否把 左模糊匹配,右模糊匹配,任意匹配三句合并成一条语句,谢谢!
[解决办法]
declare @message varchar(50)
set @message = '0755 '
--左模糊匹配
select * from AutoReply_DestCodeFilter where left(DestCode,Len(@message)) = @message and FetchMethod = 1 union all
--右模糊匹配
select * from AutoReply_DestCodeFilter where Right(DestCode,Len(@message)) = @message and FetchMethod = 2 union all
--任意匹配
select * from AutoReply_DestCodeFilter where DestCode like '%0755% ' and FetchMethod = 3
[解决办法]
select * from AutoReply_DestCodeFilter where charindex(@message,DestCode )> 0
[解决办法]
select * from AutoReply_DestCodeFilter where left(DestCode,Len(@message)) = @message and FetchMethod = 1 or Right(DestCode,Len(@message)) = @message and FetchMethod = 2 or DestCode like '%0755% ' and FetchMethod = 3
[解决办法]
--try
select * from AutoReply_DestCodeFilter
where DestCode like
case FetchMethod
when 1 then '0755% '
when 2 then '%0755 '
when 3 then '%0755% '
else '%%% '
end
[解决办法]
marco08(天道酬勤) ( ) 信誉：100 Blog 2007-1-17 20:52:38 得分: 0
--try
select * from AutoReply_DestCodeFilter
where DestCode like
case FetchMethod
when 1 then '0755% '
when 2 then '%0755 '
when 3 then '%0755% '
else '%%% '
end
---------
赞
