SQL replace from list

I'm trying to figure our how I can replace a string using data from another table I have a table that looks like this: Id Translation 1 Peter 2 Sandra 3 Olga Now I want to select all and replace the translations using a list that looks like this: Original New e # r ? lg *% So that the select list looks like this: Id Translation 1 P#t#? 2 Sand?a 3 O*%a So, for each translation, I need to have a REPLACE(Translation,Original,New). Or in other words: I need to go through every "Translation" in my first list and make another loop in my replacement table to see what to replace Bare in mind that the first list has 25'000 rows and the second has 50'000, so I can't just type it by hand :) EDIT Just to clarify: The Original and New from my look up table can be both letters and words so the table can looks like this: Original New one two three fifty sun moon