Converting int to real in SqLite

Problem:

I have a INT field in SqLite and I want to format the result into “real” format.

Solution:
To show the real number of an integer field you need to * the number and then / 100.

SELECT something*1.0/100 FROM somewhere

Happy programming.sql