hi sunshine i hope this case statement work

CASE

WHEN (@Variable NOT IN ('here', 'or here'))

THEN

SELECT @errorMsg = 'message here'

ELSE GOTO ERROR

END