"Is Not Null" vs "Not Is Null"

developingprogrammer
developingprogrammer used Ask the Experts™
on
Hey guys, according to this page, is not null and not is null are the same

http://stackoverflow.com/questions/4070207/what-is-the-difference-between-is-not-null-and-not-is-null

However when I am using not is null for a findfirst string I get an error. However is not null works perfect.

So what's the difference and what do y'all recommend I use? Thanks guys!! = ))
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
I (we) recommend what works perfect.

/gustav
Hi,

I would also not think too much about that: The experts of the other forum already have discussed it and came to the conclusion that the optimizer, the SQL parser will analyze that and convert that into the best possible plan. Normally "IS NULL" and "IS NOT NULL" is the preferable way as it belongs together as one expressions, where "NOT IS NULL" are two different expressions of "NOT" and "IS NULL".

But anyway: Use the tool I've linked in one of your previous questions to show the execution plan of Access and you'll see what happens...

Cheers,

Christian
haha gustav okie dokes! = )

got it Christian! i think the Not Is Null is 2 expressions is what i was looking for - now i understand it better.

thanks Christian and gustav!! = ))

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial