case is not control flow statement. its just a conditional expression
so your condition have to be
declare @Type int
set @Type=1
select * from tbl_outlet ot
left join tbl_brand bn on bn.bnd_otl_id=ot.otl_id
where ot.OTL_NAME like case @Type when 1 then '%A' end
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Case in where clause
Posted - 01/31/2013 : 01:17:25
