SQLite Forum

HEX - What is the reverse function?
Login
How do I get the original values , i.e. reverse HEX?

E.g. 

sqlite> .mode column
sqlite> select Hex(42),hex("answer to life");
Hex(42)  hex("answer to life")
-------  ----------------------------
3432     616E7377657220746F206C696665
sqlite>

How do I get back the original values?