On Mon, Sep 15, 2014 at 3:02 PM, Nelson, Erik - 2 <
[email protected]> wrote:
> When I query a field defined with type 'real', I get '.0' appended to the
> results for whole numbers. For example if the value in the field is 1, it
> appears as 1.0 in the query results.
>
> Is there some way for me to change this?
>
Instead of "SELECT x FROM..." you could enter "SELECT printf('%g',x) FROM
...".
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
