1) Is it possible?
2) Is in possible with IN?

E.g.

column ID is an INT

...
WHERE ID IN
CASE
WHEN @str = "A" THEN (1, 2, 3)
WHEN @str = "B" THEN (4, 5 ,6)
END

Thanks in Advance ...