Microsoft SQL Server CASE Statement Searched CASE statement
Example
In a Searched Case statement, each option can test one or more values independently. The code below is an example of a searched case statement:
DECLARE @FirstName varchar(30) = 'John'
DECLARE @LastName varchar(30) = 'Smith'
SELECT CASE
WHEN LEFT(@FirstName, 1) IN ('a','e','i','o','u')
THEN 'First name starts with a vowel'
WHEN LEFT(@LastName, 1) IN ('a','e','i','o','u')
THEN 'Last name starts with a vowel'
ELSE
'Neither name starts with a vowel'
END
