"Is Not Null" vs "Not Is Null"

Posted on 2013-09-02
Medium Priority
Last Modified: 2013-09-03
Hey guys, according to this page, is not null and not is null are the same


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!! = ))
Question by:developingprogrammer
LVL 53

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1000 total points
ID: 39459533
I (we) recommend what works perfect.

LVL 24

Accepted Solution

Bitsqueezer earned 1000 total points
ID: 39459568

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...



Author Comment

ID: 39460100
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!! = ))

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question