We are trying to "cleanse" some business names on a table. There is a lookup table that has all the to and from strings. Example: "CO" to "COMPANY" / "INC" to "INCORPORATED".
He have tried REPLACE and REGEXP_REPLACE from the NZ SQL toolkit, but we are getting a row returned for each row in the lookup table. I can nest the SQL, but it would have to be changed for each translation rule addition or deletion. Is there a way to accomplish this in one step and have just one row returned with all the translations?
Likes before 03/04/2016 - 0
Views before 03/04/2016 - 640