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.6 Code Fragment