New answers tagged replace
The doubling up is because of your nested parenthesis. Processing will start with the inner-most pair and work outwards. In this case the innermost replacement is 1 -> Apple meaning 11 -> Apple1 -> AppleApple. Reverse the nesting, starting with the longest source value and work outward. Better still, put the mappings in a separate table and join to ...
Top 50 recent answers are included