Problem in series order by

Databases
1

Dear All

Please help me to resolve this issue

I am a having a table which is having a coloum containing a series like zc500, zc501, zc502…zc800, zc801, zc802…zc8010,zc8011,

when I am executing the query on this table like

select Veid from table order by veid

It is displaying like this zc500,zc501,zc510…zc800,zc801,zc8010,zc8011,zc8012

but it should display like this zc801,zc802,…zc8010,

please help me to resolve this issue

Thanks&Regards.
MD.Samiuddin

2

ORDER BY CAST(SUBSTRING(veid FROM 3) AS UNSIGNED)

3

Thank you very much.
Problem is solved, I got the desired result with your solution
Regards
Samiuddin