So, I needed to get a really low percentage and I went to the SQlite3 command prompt and I typed,
select round(133/122000,10) as t; that gave me 0.0. Then, I said, ok, let's try this, select round(1/2,10) as t; that also gave me 0.0. Then I said, hmmmm, let me try this, select round(10/2,10) and that gave me 5.0, which is what I expect. Is there a way that I can calculate some fractional numbers in the sqlite3 command line? I am using v3.8.6. Thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users