Another SQL poser for you

Is there an efficient way change a single letter in every row in a name column?

I want to increment the vowels in football player names, so for instance Beckham becomes Bickhem.

No.

Make a program that reads the column, replace "e" with "i" and write the column back.

Could make it in any program that can access your database.

Use Getvowel(text,false)...set to true if you consider tomatoes a fruit.

can't you just export the whole lot to a csv file, then do a find and replace several times, then import it back in again?