In the last episode (Jan 12), Richard Davies said: > Does anyone have any ideas on how to round a number in the form > float(3,4) to the nearest sixteenth of an inch. > > eg ending in > .0625, > .125 > .1875 > .25 > .3125
ROUND(myfield*16)/16
should work.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
