9.8 BCONCAT

Note: Built-In Function Rules     Usage Options

Concatenates up to five alphanumeric strings to form one string as a return value. Trailing blanks from each string are truncated and one blank is reinserted between each string during the concatenation operation.

Arguments

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

U

Req

1st string to concatenate

1

Unlimited

 

 

2

U

Req

2nd string to concatenate

1

Unlimited

 

 

3

U

Opt

3rd string to concatenate

1

Unlimited

 

 

4

U

Opt

4th string to concatenate

1

Unlimited

 

 

5

U

Opt

5th string to concatenate

1

Unlimited

 

 

 

Return Values

No

Type

Req/ Opt

Description

Min Len

Max Len

Min Dec

Max Dec

1

U

Req

Concatenated result string

1

Unlimited

 

 

2

N

Opt

Length of returned string

1

15

0

0

 

Example

Concatenate a first name and surname to get a print name field.

USE BUILTIN(BCONCAT) WITH_ARGS(#FNAME #SURNAME) TO_GET(#PRTNAME)