replace
Replaces all occurrences of "string_expression2" in "string_expression1" with "string_expression3".
Syntax
replace ( string_expression1, string_expression2, string_expression3 )Example
replace ( [Sales (query)].[Sales staff].[Position code], A, a )Result
Returns position codes with all occurrences of "A" replaced by "a".