Cory> The field contains 1234.5678, MySQL returns 1234.57, don't want that!
select Round (field/1000, 4) from ...
Ivan
__________________________________
One World, one Web, one Program
-- Microsoft promotional ad
Ein Volk, ein Reich, ein Fuhrer
-- Adolf Hitler
__________________________________
http://alas.matf.bg.ac.yu/~mr02014
____ ___ _ _ _ __ ___ ____ _____
/ __/___ __ ____ | __| _ _ ___ \
/ _/ / . / _\/ \ | _| \ \/ / ._\ Ivan Cukic, Form Eye 2003. \
/_/ /___/_/ /_/_/_/ |___|_\ /\___> web development and design /
<__ / _ _ __ ___ ____ /
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
