Thanks

GSquared, Kingston Dhasian

I don't think that case work in where clause, But I didn't check it. You can rewrite the condition as following:

My query is

DECLARE @var AS VARCHAR(4)

SET @var = 'TST2'

SELECT...