Hi There: I have a query where I get an average of weekly miles. For example:
Average Weekly Miles: 3.4285714285714
How would I get this number into a more read format? Such as 3.42. I have tried the truncate but I can't seem to get it to work. Does any one have any suggestions?
"SELECT TURNCATE(AVG(distance)), rest of the query ....
Thanks - CH __________________________________ Craig Hoffman - eClimb Media
v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _________________________________
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]