Versions Compared

Old Version 2

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version Current

changes.mady.by.user Fabiola Arias Navia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

9.25 CONCAT

Note
Note: Built-In Function Rules     Usage Options

Concatenates up to five alphanumeric strings to form one string as a return value. No truncation of trailing blanks is performed by this function.

...

For the maximum possible length of a field type please refer to Field Type Considerations.

Examples

     USE BUILTIN(CONCAT) WITH_ARGS(#VAL1 #VAL2 #VAL3 #VAL4 #VAL5) TO_GET(#VAL6 #SIGN150)

Example number

#VAL1 length

#VAL2  length

#VAL3 length

#VAL4 length

#VAL5 length

#VAL6 max length

#VAL6 type

#SIGN150 returned value

Example 1

2

2

2

2

2

7

Alpha

10

Example 2

256

2

2

2

2

7

Alpha

256

...