Remove null values in case statement SQL Server

Viewed 31

I am using a case statement like below:

(Case Id when '5' then value end) as 'A'
(Case Id when '6' then value end) as 'B'

This is also returning null values, which I want to remove or exclude. How can I do that?

0 Answers
Related