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 <d...@sqlite.org> wrote: > On 10/18/18, John Harney <john.har...@grupobimbo.com> 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 > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users