ISNULL and Coalesce problems

I am trying ISNULL and COALESCE and neither are working for me. What am I dong wrong?
image

image

An empty string is not a null value...you can try:

coalesce(nullif(MAST_AIRBILL, ''), HOUS_AIRBILL)

4 Likes

Works perfectly. Thank you!