Order by

[Pgmer]

Hi All,
I have column which consist of data like

AB1
AB2
AC3
AD5
AB1
AB2

When i do order by this coulumn, its not ordering properly.
It should order like
AB1
AB1
AB2
AB2
AC3
AD5

Thanks

[debasisdas]

if the format is always same, order by last character.

[Pgmer]

Hi debasis,
Thanks for reply..
The format is not same some times the data will be like

AB1A
AB2B

I think we cannot include this column in order by.
Any idea or suggestions?

Thanks

[debasisdas]

if the format is always same for position of number in the character string ?

[adam_k]

I think you are looking for

order by left(column_name,1),substring(column_name,2,1),substring(column_name,3,1)

[debasisdas]

that will work if the format of data is consistent across.