GRNV-1415-RESH-132
 GRNV-1415-RESH-13
 GRNV-1417-RESH-2
 GRNV-1415-RESH-8
 GRNV-1416-RESH-12
 GRNV-1411-RESH-1
 GRNV-1415-RESH-13
 GRNV-1415-RESH-99

select   GRN id,GRN data1 from tbl_receipt
where Active=1
and  ArticleContrasted=1
and LocationID=41
order by LEFT(GRN,PATINDEX('%[a-zA-Z0-9]%',GRN)-1) asc