DECLARE @RealDescription AS VARCHAR (100) SELECT @RealDescription = CASE Description WHEN NULL THEN 'Not declared yet' WHEN '?' THEN 'Not completed yet' ELSE Description END