I know what null means. What I was trying to state was I've nulled anything that had no visible characters in there. It was the context I was trying to figure out in the question. In the same database, there was a "make table" query I had that created a column that did not previously exist (column A:"") and the next query didn't recognize it as null, so I had to null it out just to show that the information in the newly created column had a null value.
Maybe I can't convey myself in a savvy programming manner, so please excuse me for trying to explain my issues.
If it's related to this dilemma that I'm having, then I'm stumped and I obviously need a refresher. Does anybody know the answer to this riddle and if so, please throw me a bone? I thought this is what a forum's purpose was.
I don't seem to understand how I can't use = and not <>. That's it. As for the null inquiry, I apologize for attempting to answer. I tried to explain, as well as post my db.
Cervantes, the problem is when you have null in one side of equation and a number in the other side (say null<>2) the resualt is false as the whole equation is wrong because null isn't a number to be comapred with numbers so you shall put another iif statement to convert all null items to 0 during calculations to make the equation to function correctly as bellow:
Basically bollean logic breaks down in SQL when NULLS are involved. A NULL is an unknown value. Hence comparing it to other values results in an unknown return. If you substitute the word unknown for NULL above it makes lots of sense. (Just read StarTrekker's post - same point )
This is what is happening in your expression. You need to handle comparing known values to unknown values (i.e. NULLS).