• 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)