Does mySQL have an equivalent to PHPs intval() function? I have fields whose contents are "Less than 100", "Less than 200", "Less than 300", and I want to do a SELECT * FROM my_table WHERE $mynumber <= intval(myfield) thanks, bill -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]