SUBSTRING From LANSA previous page next page SUBSTRING All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/Components for this ExampleFunction SET189M or form S_189FMYou can substring the retrieved values:SELECT_SQL FIELDS(#SURNAME (#GIVENAME 'SUBSTR(SURNAME,3,5)')) FROM_FILES((PSLMST))TypeNameCodeDescriptionFunctionSET189MSET189MSELECT_SQL - Substring Form S_189FMS_189FMSELECT_SQL - Substring previous page start next page
