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.
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.