Hello,
i have a database with a name column, but i want to make a test dataset with that same db but i want to move a few characters around so like
change peter to aetep like replace all "A" with "P" but what ive found or what ive figured should work doesnt

was just hoping someone could help me with an update query to run. would be a pain doing it manually.

thanks



Tried
select replace(f_name,"o","a") but it says replace.prg isnt found