From: Dan Nelson
Date: January 12 2004 10:36pm
Subject: Re: Rounding to nearest one sixteenth of an inch.
List-Archive: http://lists.mysql.com/mysql/157503
Message-Id: <20040112223604.GB92646@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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
	dnelson@stripped