Strings and Numbers with SQL

Could I possibly start anymore threads about the same piece of code. Well the answer is yes.

I have the code running now and it works beautifully. It updates and inserts when it should and what not.

Now, I am trying to optimize it because I any changes I make to it will make it run significantly fast. Here is the problem:

I am running the script against the same file every time so after the first run through, the next run should not have any inserts or updates in them because they should have been taken care of the first time around. And they are. However, it is still doing updates. But what is weird is that it is updating the same value over and over. For example:

Index: 34
DRN: Change from 0 to 0
UPDATE Sheet1 SET Delivery_Route_Number= 0 WHERE Member_Number=578502689;
DRN: Currently is 0 = 0

The first DRN says what it is before the change and what I am changing it to. The second DRN says after the change and what I was changing it to. I printed these characters out in ASCII form and they are all the same. I don't understand why it is doing this. I think it might have to do with the database wanting a number field and this is a string. But it doesn't do this on other number fields. Just this one and like 2 others (1 is a date field).

So any thoughts on how to fix it?

bttt...Just once.

What's a DRN?
Make sure you're comparing strings with strings, or numbers with numbers...

Yes and I think that might be part of the problem in that I am either not comparing strings with strings or numbers with numbers. The problem is that I have several number fields set up and this only happens on some of them.