Applies to Infiniti v8.0 or later
Returns a string created by concatenating of any number of strings or question references.


Concat( p[1], p[2], .., p[n] )


p[n] An expression or value to be concatenated, which may include equations, question references and function calls.


Build a sentence:
This example shows the Concat() function being used to build a typical sentence.
Concat([q1.firstName], " has ", [q7.NumberChildren], "children")
or to handle the plural
Concat([q1.firstName], " has ", [q7.NumberChildren], iif(isequal([q7.NumberChildren],"1")," child"," children"),".")
Assuming ‘John’ has two children the concat() function would return: John has 2 children.


Related Articles



format sentence joinif join first firstname numberchildren number children