Yeah, not nice solution. Anyway, I'm stuck too to do such.
Something looking pretty useful was posted on other forum:
CREATE TABLE X_REPLACEMENTS (
string NVARCHAR(100),
replacement NVARCHAR(100));
INSERT INTO X_REPLACEMENTS VALUES ('abc','123');
INSERT INTO X_REPLACEMENTS VALUES ('xxx','666');
DECLARE @v_str NVARCHAR(1000);
SET @v_str = 'abc..xabc xxx xyz';
SELECT @v_str = REPLACE(@v_str,string,replacement)
FROM X_REPLACEMENTS;
PRINT @v_str;
Work nice, anyway it would be nice to use something like this in update or even in select query (meaning updating data in table1 using replacements from table2). Any idea how to accomplish this?