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]