Home Forums SQL Server 2005 SQL Server 2005 General Discussion CASE IN in where clause RE: CASE IN in where clause
jeetsingh.cs
SSCommitted
Points: 1741
More actions
February 19, 2013 at 4:41 am
#1589127
it think the way you have written the query is not right
case statement should be the part of the expression
in your case you can use case like this
select * from sys.objects
where name=(case when name='t1 ' then 'condition '
else 'condition2'
end)