I have a column that stores numbers, i.e. "4,000" "135" "6"; What should I set the Column Type as, in order to sort properly by that field.
the problem: if it's "TEXT", it sorts according to first number, thus the above numbers would be: "135" "4,000" "6" this is not acceptable. But if I set the field to "INT" then I can't store the number 1,000 it won't allow the comma, which I really want. Is there a field type I can choose that does this? Or do I just have to reformat every number that I retrieve and add in commas every three digits? please tell me I don't. thanks in advance, chadwick ******************************** Chadwick Meyer 816 46th Ave - San Francisco CA 94121 415.876.0980 www.chadwickmeyer.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
