I have a fairly basic question: How do I sort numerically? Normally when I query using "ORDER BY (field)", it orders by the first digit (i.e. 1, 10, 2, 21, 3, 32) rather than by number (1, 2, 3, 10, 21, 32).
Thanks for any help Dave __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php