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
이렇게 정의 된다