This will work
SELECT * FROM [TableName] ORDER BY [Date] DESC, CAST(REPLACE([SerialNo], '37/1/1/ROR/','') AS BIGINT) DESC
My suggestion is if you create additional columns by splitting the
SerialNo
column then it will be easy to handle these kind of things instead of above way.
Example:
SerialNo - AC1 AC2 AC3 AC4 AC5
37/1/1/ROR/90 - 37 1 1 ROR 90
Note : AC - Additional column