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