>What if you copy that data in Excel?

Same thing. I just sent you a PM, would you please do this favor for me in VFP, then I put this list in IN clause in UPDATE.

Thanks a million in advance.

E.g. here is what I tried in SSMS

update People set PersonType = dbo.GetPersonType('F',Gender) where LastName + FirstName IN 'ZoeSoble' and it worked.

Now I just need this as a list. Though here we may have a problem with the concatenation for common names, but fortunately this is not the case here.