try

ORDER BY CAST(SUBSTRING(DATA+CHAR(32),1, PATINDEX('%[A-Z]%',DATA+CHAR(32))-1 ) AS INT)

where data is the column containing data like 12th, 9th, 3rd etc.