Subject sql decimals From Charlie <tm@tc.com> Date Sun, 07 Jan 2024 17:25:38 -0500 Newsgroups dbase.getting-started sql = "select sum(qty) from collection The sun(qty) generates decimals and zeros like this..  9.00.  I would like it to look like this.  9 I have tried round() in the sql which doesn't seem to work.  I have also tried to find a way in properties but I can't   seem to fix this which I would think should be easy.  Any suggestions?