sql if empty else return table code example

Example: sql if empty then

SELECT COALESCE(NULLIF(SomeColumn,''), ReplacementColumn)
FROM SomeTable