Page History
...
In the following example, the xEmployee table has two columns Surname and GivenNames. Surname is A(20) and GivenNames is A(20). If the Surname was "Smith Smith" and Surname was "John John", a simple concatenation virtual would create a virtual column called FULLNAME with a result of "Smith John Smith John".
Using the following code fragment:
...
#FULLNAME := #SURNAME + ', ' + #GIVENAME
...
the code fragment virtual column FULLNAME will have a result of "Smith, John".