[ 
|../../index.htm#lansa/l4wtgu03_0350.htm]
You are here:
Concatenation Example
Following is an example of a concatenation virtual column.
The Employee table contains the employee's last name in a column SURNAME defined as A(20).
The Employee table contains the employee's first name in a column GIVENAME defined as A(20).
A concatenation virtual column can be created named FULLNAME defined as A(40). This column will have the first name followed by the last name:
Virtual Column Name: FULLNAME
Column Names |
Length |
Description |
|---|---|---|
GIVENAME |
20 |
Employee Given Name |
SURNAME |
20 |
Employee Surname |
|
Also see
3.3.10 Code Fragment
[ |../../index.htm#lansa/l4wtgu03_0350.htm]