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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
