You are viewing the documentation for Blueriq 14. Documentation for other versions is available in our documentation directory.
CONCATENATE
Use the '+' (plus) operator to concatenate strings or a combination of strings and other type values to produce a single string value.
Syntax
string1 + string2 + ... + value1 + ...
Inputs
- string1 - The first string that you want to concatenate.
- string2 - The second string that you want to concatenate.
- value1 - A value of some type of number, date or boolean that you want to add to the new string value.
Return type
- string
Examples
| Expression | Result | Type |
|---|---|---|
| 12 + " kilometers" | "12 kilometers" | String |
| "This statement is " + TRUE + "." | "This statement is true." | String |
| "I was born on " + Me.birthDateAndTime + "." | "I was born on Tue Dec 01 23:00:45 CET 1970." | String |
| ( UPPERCASE "hello" ) + ( LOWERCASE " WORLD" ) | "HELLO world" | String |
| UPPERCASE( "hello" ) + LOWERCASE( " WORLD" ) | "HELLO WORLD" | String |
Suppose Person.FirstName = "Carl" Person.LastName = then Person.FirstName + Person.LastName | ? (UNKNOWN) | String |
Note the correct use of parenthesis in combination with concatenation, see UPPERCASE and LOWERCASE syntax.
There exists a STR_CONCAT ( string , string ) function in the expression language. As it can only concatenate two strings, and is much longer in typing, we advise to use above way for concatenating strings.
Overview
Content Tools