problem in series order by

[samiuddin.adse]

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

[r937]

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

[samiuddin.adse]

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