The question is: why use varchar? Why not use INT, then format to includes commas when displaying?
-----Original Message----- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 3:38 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] numeric string problem Hi, I am using VARCHAR for price column : 600,000 700,000 etc when I use : PRICERANGE<='$Price' it works fine except when the $Price moves to 7 digit as 1,000,000 in other words the" less than " does not work when comparing 6 digit and 7 digit figures I am not sure how to compensate for this. Thanks Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php