.
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'
2018-07-19
[Informix][SQL][String]取部份字串(SubString)
- 2342
- 0
