If I have a field in mySQL consisting of a number with 8 digits a decimal point and 4 more digits what is the field type it needs to be to sort it numerically? I've tried decimal(8,4) but it converts everything to 99999999.9999. I've also tried float but it doesn't sort numerically. All of the other integer types cut off the decimal bit. Any help would be appreciated. Susan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
