Subject | order varchar as number |
---|---|
Author | UmSoft |
Post date | 2003-02-05T18:31:53Z |
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
'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