I have column which consist of data like
When i do order by this coulumn, its not ordering properly.
It should order like
if the format is always same, order by last character.
Thanks for reply..
The format is not same some times the data will be like
I think we cannot include this column in order by.
Any idea or suggestions?
if the format is always same for position of number in the character string ?
I think you are looking for
order by left(column_name,1),substring(column_name,2,1),substring(column_name,3,1)
that will work if the format of data is consistent across.