SQL Coalesce with empty string

Question

I have the following: ``` Select Coalesce(Other,Industry) Ind from registration ``` The thing is that `Other` can be an empty string or `NULL`. How do I get `coalesce` to work such that if `Other` is an empty string, `Coalesce` still returns `Industry`?

Accepted Answer

Use a `CASE` expression or `NULLIF`:

```
SELECT COALESCE(NULLIF(Other,''),Industry) Ind FROM registration
```

SQL Coalesce with empty string

Solution

Problem