coalesceEmpty

select *, coalesceEmpty(column, param) as returnValue from tableName

-- column: column name to check if it is empty
-- param: if column is empty return param value
-- tableName: name of a table

-- returnValue: if column value is not empty columns value is returned, otherwise param value will be returned

select *, coalesceEmpty(destIP, '192.68.23.1') as newDestIP from table