>'Missing comma' error
>

select ssns
>scan
>	iif(ssn1>ssn2, insert into ssnpers values(str(ssn1) + str(ssn2)),insert into ssnpers values(str(ssn2) + str(ssn1))
>endscan

Not exactly sure, what you're up to, but check KEYMATCH(), INDEXSEEK() and LOOKUP() functions in VFP Help.