Informix SQLString 取部份字串 SubString 函式
--Col欄位值 = 'ABCDEF'
SELECT Col[1,2] as A, Col[3,5] as B FROM TAB1;
----------------------------------------------------------
結果:
A='AB'
B='CDE'
SELECT Col[1,2] as A, Col[3,5] as B FROM TAB1;
----------------------------------------------------------
結果:
A='AB'
B='CDE'
留言
張貼留言