Select column, if blank select from another April 30, 2023 by Tarik How about combining COALESCE and NULLIF. SELECT COALESCE(NULLIF(SomeColumn,''), ReplacementColumn) FROM SomeTable