Sorting Varchar

[kc68]

How do I set up a column (cost) that contains numbers and text so that the 
numbers will sort the numbers accurately?  Using varchar results in a sort 
based on the first digit, so that I get e.g. 1, 10, 100, 3. . . when the 
command is "order by cost." Almost all of the text is "By County."

Ken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]