Probably an easy question but have a short deadline. I have two fields each with the a possibility of NULLS. I already did a case when but now realized that I may still have NULL values. How would I get rid of the final NULL if both fields are null. is it possible to nest inside an already created CASE WHEN?
Here is my current Case When.
CASE WHEN fp2.ConfirmDate IS NULL THEN fp2.CommitDate ELSE fp2.ConfirmDate END