how to replace all the email id records with progress 4gl

The problem here is I want to update the email ids, I want to update like user@abc.com to user@xyz.com


I have selected all the email ids like this,

for each table where
table.email matches "*" + "@abc.com" + "*" no-lock :
Display


I can't use replace function, since each email ids will be of different length. Is it possible to change email ids like this ? Please share with me.

Continue reading...