Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

get null data?

Status
Not open for further replies.

flamenco

Computer
Sep 26, 2005
4
Hi:

I'm using access.
Suppose the next table "birthdays"

birthdays
--------------------------
name birthday
--------------------------
john 25/03/1984
gabriel
diana 08/02/1983

I want to make a query that returns "name" where "birthday" does not have value.

I tried this query:

SELECT name
FROM birthdays
WHERE birthday=null

the query does not return any name

How can I make the query?

Thanks!!
 
Replies continue below

Recommended for you


SELECT name
FROM birthdays
WHERE birthday is null
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor