Help w SELECT SQL code

[SinCity]

How come this code doesn't seem to work?

SELECT *
FROM Table1
WHERE (((Table1.Email)=""));

Here is what my table contains...
Name Email
John
Joe
Smith
Crest

There is nothing in the Email column for each entry, yet the results of my
SQL code returns 0 rows.

Help!

 

[Norman Yuan]

Assume the column "Email" is Text type. Does it allow NULL (e.g. the
column's "Required" property is set to "NO")? If yes, the the cell in table
looking like empty could be either ''", or null.

Try this:

SELECT *
FROM tbale1
WHERE (Email IS NULL) OR (Email='')