[Informix][SQL][String]取部份字串(SubString)

  • 1504
  • 0

.

1 base(第一個字index是1)

--id欄位值 = '05003'
select id, id[1,2] as month_no, id[3,5] as sn from tablea;

----------------------------------------------------------
結果:
month_no='05'
sn='003'