I need to apply tens of replace statements to clean text. For that, I've got the below SQL script but would like to transfer it to QV. I've tried with peek loops but with no success. If I'd nest the replace statements, I'd end up with something like a meter long script line.
WHILE @@ROWCOUNT >0
SET Text = REPLACE( T.Text, V.Variable, V.Replacetext)