Order by Alphanumeric

ORDER BY
CAST(LEFT(t.ComponentName,PATINDEX('%[^0-9]%',t.ComponentName)-1) AS INT)

Left Right Function

Query :
select docpath,RIGHT(DocPath,len(docpath)-47) as RH,LEFT(DocPath,47)LH from FeasChecklistDocument where TranMasId = 200 and TranId = 1

Result:
docpath  =  \\dataserver\SFPL System\Doc\Marketing\Enquiry\fgs02722_04.03.2016.pdf
RH         =  fgs02722_04.03.2016.pdf
LH         =  \\dataserver\SFPL System\Doc\Marketing\Enquiry\