Glad to help
Jaime

>Thanks. That did exactly what I needed. I don't use VFP as often as I used to so I forget how to do certain things.
>
>Bill
>
>>Bill
>>This will work in any version of Fox.
>>Assuming your field containing the whole name is NAME, and you add two fields to your table, one with LASTNAME and one with FIRSTNAME, just run the following:

>>replace all LASTNAME with left(NAME,at(",",NAME)-1),;
>>            FIRSTNAME with right(NAME,len(NAME)-at(",",NAME))
>>

>>Cheers
>>Jaime
>>