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
>>
Why do programs stop working correctly as soon as you leave the Fox?