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