simple CASE
The CASE expression in SELECT statement in SQL Server 2012
The CASE expression is used in SELECT, UPDATE, DELETE statement
and in WHERE, IN, ORDER BY and HAVING clause.
The CASE expres ... ]
WHERE [Title] is NOT NULL
AND [LastName] LIKE 'Va%';
The next post will be about use CASE expression in other statements.