I use the below query to summarize multiple rows into a single row. Works good
GROUP BY REF, DATE, LEV1, LEV2
Sometimes the FROM or TO columns have no value and are null. When there is no value, I want to default 'UNR'. I have been playing with COALESCE, but many errors.
How Can I get the nulls to default to 'UNR'?