Hi, I have a serious problem with a site. It's a ASP site running on IIS5 and MySQL 4.0.15.
I have a DECIMAL(10,2) field in a table. I've now experienced that on some days, the decimal digit is ignored, meaning that a value of ie. 14.00 is represented af 1400, 135.00 as 13500. I have search all the documentation but I haven't found nothing. I've solved the problem using the FORMAT function but I'd preffer to using the code with formatnumber asp function instead the rewriting all the code and querys. Does anybody now the possible solution? TIA, Alessandro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]