SQL CASE [Column] WHEN IN ('case1', 'case2') THEN 'oops' END?
63,463
Solution 1
SELECT CASE WHEN [Option] IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go' END
Solution 2
You can use the CASE WHEN <predicate> THEN <value> ... END
option, rather than the CASE <value> WHEN <value> THEN <value> ... END
option.
SELECT CASE WHEN [Option] IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go!' END
... but if the values are in a table, you could just do an outer join (and
CASE WHEN t.Value IS NULL THEN 'Not in list' ELSE 'In list' END
, or
CASE WHEN EXISTS (SELECT * FROM yourTable t WHERE t.value = [Option]) THEN 'Bad' ELSE 'Ok' END
...without a join.
![Shimmy Weitzhandler](https://lh4.googleusercontent.com/-6krMF6SwdIY/AAAAAAAAAAI/AAAAAAAADzE/5y9xrjn621Q/photo.jpg?sz=256)
Author by
Shimmy Weitzhandler
Updated on July 09, 2022Comments
-
Shimmy Weitzhandler almost 2 years
Is there a way to check a CASE when it's in an array:
SELECT CASE [Option] WHEN IN (1, 3, 99) THEN 'Wrong option' ELSE 'You go!' END