"Most of the operations of relational algebra involve the use of logical operators, operators that usually return a Boolean result—that is, True or False." - quote from your article.

That is...

I'm repeating myself now...NULLs have no determinable value.

The boolean predicate is NOT behaving as expected! I expected it to return TRUE or FALSE based...

Sorry. NULL has no value at all...not even '0'. The only information that can be taken from a NULL (on it's own) is that no value has been entered for...

Really sorry but don't have time to write a long post or sort out the code for you but here is the idea if it helps:

Create a trigger on your...

Thanx Ron

Of course, if that was your situation, then you would have to program for that. My situation is different...more a data cleansing issue and NULLs need to be cleansed...

Thanx

Was hoping to avoid any OR's in the scripts. I was under the impression that

WHERE field1 <> '0'

would have been enough to pull back all records where the value...

Mmm...i am not sure we're talking about the same thing.

I am not looking for NULLs. I would use IS NULL or IS NOT NULL for that.

I am looking for where...

Sorry, I meant TRUE for rows where field1 is null and therefore they should be returned.