On Monday 12 Jan 2004 22:23, you wrote:
> Richard Davies wrote:
> > Does anyone have any ideas on how to round a number in the form
> > float(3,4) to the nearest sixteenth of an inch.
>
> Multiply by 16, round, divide by 16.
Obvious really,
update table1 set field1 = (round(field1 * 16)/16);
I was looking for the hard answer and not finding it.
Thank you.
--
Regards
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]