How to have a dynamic concat where user can specify wad fields to concat?
Below code are static and hardcoded where i specify the fields in my program. How to make the field dynamic in the sql statement?
Select <b>fname lname</b> into <b>(value1, value2)</b> from ZSTUDGARY where
admino = '012345'.
CONCATENATE value1 value2 INTO NAME.
if field1 is NOT INITIAL.
append field1 to it_fldtab.
write like this for all 10 fields.
they don't need to be in the same order as they are in data base