I have several records and one of my field is segment_number and it is as of:
PID_1
PID_2
PID_11
PID_14
PID_6
I want to sort all the records based on segment_number field but as its is a string and the number is at the end of the string I am not able to sort it in ascending order of numbers.
If I use ORDER BY segment_number,I get the order as this which is not what I want:
PID_1
PID_11
PID_14
PID_2
PID_6
What I want:
PID_1
PID_2
PID_6
PID_11
PID_14
Any leads will be appreciated.