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
ORDER BY CAST(SUBSTRING(veid FROM 3) AS UNSIGNED)
Thank you very much.
Problem is solved, I got the desired result with your solution
This topic is now closed. New replies are no longer allowed.