The replace suggestion was close, but I finally found a syntax that worked! Instead of SET department_name = REPLACE("${parentName}",'&','&') the statement that seems to work is SET department_name = REPLACE("${parentName}",'amp;','') Thanks for all the suggestions!!