I have an integration type project where my select column often has this code:

```
select 
CASE MyColumn
    WHEN '' THEN '&' 
    ELSE MyColumn
END

```

Is there a simpler approach? Sort of like coalesce with nulls?
I'm finding the query really hard to read, etc.

Thanks