>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

In SQL Server you will use REPLACE function to replace one character with a different character. You will need to pass this query using sqlexec function using valid connection handle.

In VFP the functions to replace one character with another are CHRTRAN and STRTRAN.