CASE Usage [Home]


DECLARE @RealDescription AS VARCHAR (100)

SELECT @RealDescription =
CASE Description
   WHEN NULL THEN 'Not declared yet'
   WHEN '?' THEN 'Not completed yet'
   ELSE Description
END