How can we use “Decode” functionality in SQLite?

Question

I would like to use "Decode" functionality in SQLite select statement.

From what I have read, it looks like there is no such function in SQLite.

What could be a workaround so that we use something similar to "Decode" in SQLite?

Answer 1

There is no decode in Sqlite. Use "case statement instead" it's standard SQL an runs on any DB - which is better anyway.