You have to pad the values. For instance, fill the front with zeros.

00001
00002

UmSoft wrote:

>I have a field cod : varchar(20). Posible value: '1',
>'2','aa','11','21', etc (numbers and strings).
>Order by cod : '1','11','2','21','aa'.
>I want an order like this: '1','2','11','21','aa' ?
>Who to do this?
>
>__________________________________________________
>
>Do You Yahoo!?
>
>Everything you'll ever need on one web page
>
>from News and Sport to Email and Music Charts
>
>http://uk.my.yahoo.com
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus