If you're just targeting the substring Eric, you can REPLACE ALL Names WITH STRTRAN(Names, "Eric", "ERIC"), however be aware that would also affect something like "Erica", because it is simply a substring operation, not based on whole words.

-- Randy

>I have a dbf that has a field entitled "names"
>
>Data in this field is as
>
>Eric Den Doop
>Jos Pols
>Gomez Eric
>Terry Mcdonnel Eric
>
>In this field I want to replace "Eric" with "ERIC" && proper case to uppercase
>
>How should I do this?
>
>Please help again