• Ok the first thing to remember is that they both perform different functions

    Lets start with ISNULL statement

    WHERE ISNULL(Col1,'') = 'NOCHANGE'

    The reason you use is null is so that you don't get thie

    WHERE NULL = 'NOCHANGE'

    instead you will get:

    WHERE '' = 'NOCHANGE'

    So in your example you possible clause are as follows:

    WHERE '' = 'NOCHANGE' (this is FALSE)

    WHERE 'anything' = 'NOCHANGE' (this is FALSE)

    WHERE 'NOCHANGE' = 'NOCHANGE' (this is TRUE)

    Now using the NOT operator basicallt says do the opposite

    so NOT TRUE = FALSE

    and NOT FALSE = TRUE

    Does that make sense to you?

    ----------------------------------------------
    Try to learn something about everything and everything about something. - Thomas Henry Huxley

    :w00t:
    Posting Best Practices[/url]
    Numbers / Tally Tables[/url]

    SQL-4-Life