Ordering Data

88382Sep 13 2002

Hi there,
I have data in following order in the table.

1
2
101
201
10101
10102
20101
20102
i want data ordered like this
1
101
10101
10102
2
201
20101
20102
what should be the query and order by clause ?

Thanks

Added on Sep 13 2002

#forms

1 comment

75 views