Hi! Use the round() function.
round(14.9564, 2) = 14.96 round(32.1123, 2) = 113.11 Bye > Hello, > > > I need the ability to round off dollar amounts to the nearest 100th > of a dollar amount, IE $14.9564 to $14.96 or $132.1123 to $113.11 > > can this be accomplished with MySQL SQL function ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]