Hi, I am trying select field / 10000 as Number from table1 where id = 1; I don't want any rounding taking place, but MySQL is currently doing it. How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that! Thanks, Cory Twibell Lockheed Martin Space Systems Company Electronic Combat Development Systems [EMAIL PROTECTED] (303) 971-3184 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]