USE Indiana_ODS_VT
/*
SELECT TOP 100 * FROM FarmersImport
SELECT TOP 100 * FROM tblCamp_CT_Kevin
*/


UPDATE tblCamp_CT_Kevin SET Farmer = NULL
SELECT @@ROWCOUNT
-- Returns 696397

BEGIN
 
    BEGIN TRANSACTION
 
    UPDATE tblCamp_CT_Kevin SET Farmer = '1'
		FROM tblCamp_CT_Kevin c
		INNER JOIN FarmersImport fi ON LTRIM(RTRIM(fi.[FirstName])) = LTRIM(RTRIM(c.FName)) AND
									   LTRIM(RTRIM(fi.[LastName])) = LTRIM(RTRIM(c.LName)) AND
									   LTRIM(RTRIM(fi.[RegCity])) = LTRIM(RTRIM(c.City))
		WHERE c.Farmer IS NULL

	SELECT @@ROWCOUNT

--39604 with MailCity
--39701 with RegCity

    IF @@ROWCOUNT = 0
      BEGIN
        COMMIT TRANSACTION
      END
	ELSE
      BEGIN
        ROLLBACK
      END

 END


Thanks everyone

Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people