Case When ...

[Lotes]

Section within the standard

Example:

SELECT CASE
         WHEN team_name = 'Blue Bombers' THEN city
         ELSE '*********'
       END AS city
FROM Teams;