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