I'm trying to write a `SELECT` request with custom sorts. Values on the `STATE` column can be `active`, `suspended`, `inConstruction`, and I need them sorted in this order.

I did something like this:

```
select c.id, c.state from client c
where other_conditions = TRUE
and c.state in ('active', 'suspended', 'inConstruction') --adding this for clarity
order by replace(c.state, 'suspended', 'b_suspended') asc

```

Doing this ensures the results are in the right order but it's really ugly. Is there a cleaner, more "objective" solution?