sort records based on substring value in a column 1

[hemajb]

Hello,

I have a table with the column "name" which has values like AAO1LC,BB03RS,CC02LC,DA02LC,CRT,RAELT. i want a query to sort this based on 01,02 ,i.e based on 2 and 3 char of name.

could anyone let me know how do i need to use select statement here.

thanks

 

[byam]

select * from tableName order by substring(name, 2, 2);

where the substring syntax is:

substring(column name, start index, length)

Please check the exact synatx for the database server that you are working with.

 

[hemajb]

Thanks
It worked!!