I don't think the cast rounds, though. It just truncates. Am I wrong? RobR
On Thu, Oct 18, 2018 at 4:13 PM Richard Hipp <[email protected]> wrote: > On 10/18/18, John Harney <[email protected]> wrote: > > Recently figured this out. Seems to work fine > > > > trim(trim(round(1.111,0),'0'),'.') = 1 > > > > CAST(1.111 AS integer) > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
