hmm ok well I ended up using substring to return just the last 2 characters as another column and then sorting on that rather then trying to do it all in one step in the order by clause. Thanks ...

I'm on an Oracle 12c database; I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it ...