ASP SQL How come I cannot query field for 'NULL' values

Posted on 2006-04-12
Medium Priority
Last Modified: 2008-03-17
I have the following SQL query that returns no records. If I change the value of the where clause then data shows up fine,
I looked at the table and can see many records that contain a 'NULL' value in the field I am querying.

FROM         devsub
WHERE     (cmpbldlbl = 'null')

any ideas
Question by:tmurray22
1 Comment
LVL 52

Accepted Solution

Carl Tawn earned 2000 total points
ID: 16440338
The syntax for checking NULL in SQL is:

    SELECT *
    FROM devsub
    WHERE (cmpbldlbl IS NULL)

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

809 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