Recently figured this out. Seems to work fine trim(trim(round(1.111,0),'0'),'.') = 1
________________________________ Aviso de Privacidad y Confidencialidad // Privacy and Confidentiality Notice // Avis de confidentialit?: https://privacy.grupobimbo.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users