select goods_code from goods where left(goods_code,4)='ST-A' order by replace(goods_code, 'ST-A', '') ASC

 

a1234

a134

b212

b2233

 

이렇게 정렬된다.

 

select goods_code from goods where left(goods_code,4)='ST-A' order by replace(goods_code, 'ST-A', '')+0 ASC

 

a134

a1234

b212

b2233

 

이렇게 정의 된다