Skip to Content
0
Former Member
Oct 11, 2007 at 02:51 AM

Dynamic Concatenation

2424 Views

Hi all

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?

code----


Select <b>fname lname</b> into <b>(value1, value2)</b> from ZSTUDGARY where

admino = '012345'.

endselect.

CONCATENATE value1 value2 INTO NAME.

write:/ name.