Convert Text to Numbers in SQLite

Solution 1:

See "CAST expressions" at http://www.sqlite.org/lang_expr.html.

SELECT CAST('3.02' as decimal)
-- they aren't real decimals in sqlite, though. beware floats.