help needed in this SQL

[gtcol]

You can use the 'CASE...WHEN...ELSE' SELECT Clause in a situation like this. 'CASE...WHEN...ELSE' clause works similar to C 'IF...THEN...ELSE' clause.

gtcol