SQLite Forum

nested case statement not working
Login
Also, don't forget about the simple TRIM() function:

```
... case TRIM(job)
        WHEN 'ANALYST' then ...
```

[TRIM(s,c)](https://sqlite.org/lang_corefunc.html#trim) removes any characters specified in the string "c" that surrounds (leading or trailing) the text "s". If c is not specified, then TRIM(s) removes spaces around "s".