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