Re: Sorting Varchar

[Sasha Pachev]

kc68@stripped wrote:
> 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:

Consider having two columns - num_val, and text_val, and then order by num_val, 
text_val

-- 
Sasha Pachev
Create online surveys at http://www.surveyz.com/