[sqlite] Expressions

[Roger]

How do i use expressions in SQLite.

For instance, i want to be able to use Case when i execute my sql so
that i have a row which looks up a value rather than querying it from a
table