concat
Returns a string that is the result of concatenating, or joining, "string_expression1" to "string_expression2".
Syntax
concat ( string_expression1 , string_expression2 )Example
concat ( [Sales (query)].[Sales staff].[First name], [Sales (query)].
[Sales staff].[Last name] )Result
Returns the first name and last name; e.g., Bob Smith.