Not sure what exactly you want. From the SQL statement you posted it will always insert data for NY and KT if it does not match Fname and Sname, but only update if the state is not NY or kt. Is that what you intended? Oh, btw, is your database case sensitive?

Regards,

Jan