Hello folks-
Does anyone have a suggestion on how to order a varchar(2) column
containing values like: 'A', 'B', ..., 'Z', 'AA', 'AB', ...
What I would like to to return the tuples in this order:
A
B
C
...
X
Y
Z
AA
AB
...
Instead of:
A
AA
AB
...
B
BA
BB
...
While I would prefer to do the ordering in SQL, my application is
written perl, so I could always do the ordering perl-ically.
Thanks in advance!
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------