select SPRG,SEQ,PAPER,PAG,substring(STS,5,1) as STSPAGE,STS2,TYPE2,PSIZE,STS3,CTYPE,FIEL3,FIEL1,FIEL2,

STS,STS5,TYPE1,LEN1,PIC,TABHD,CHSTS,CHFIELD,SFIEL,PKSTR,PKEND,QRYFT,FIEL4,SFID0,SSQL0,CHMESS,SVAL0,SFIE1,SFID1,

SSQL1,CHMES1,SVAL1,SFIE2,SFID2,SSQL2,CHMES2,SVAL2,SFIE3,SFID3,SSQL3,CHMES3,SVAL3,SFIE4,SFID4,SSQL4,CHMES4,SVAL4,

SFIE5,SFID5,SSQL5,CHMES5,SVAL5,PKLST,SQL1,INQ,DEFUT,RETEX,CHKEX,MEMO,USRID,ENTDT

from M_SYSFIL

WHERE SPRG LIKE 'ACCM1500%' 

order by SPRG,SEQ




 

Created with the Personal Edition of HelpNDoc: Generate Kindle eBooks with ease