I am trying ISNULL and COALESCE and neither are working for me. What am I dong wrong?
An empty string is not a null value...you can try:
coalesce(nullif(MAST_AIRBILL, ''), HOUS_AIRBILL)
4 Likes
Works perfectly. Thank you!