postgresql order by

wxdqz

New Member
I have three records in varchar field. When I sort the records in asc order, the output is something like this:
n,
n1,n
n,n
But I expect the result would be:
n,
n,n
n1,n
Why? How can I solve the problem?
Thanks.
 
Back
Top