Select *,X=
CASE
WHEN Y=0 THEN 0
WHEN Y=1 THEN 1
ELSE 2
END
From A
Where (Y=0) or (Y=1)