Q:

not isnull or empty in sql statement does not block nulls

simple question. 
where not isnull([AddStreet], '') = ''

This seems to be failing, and I still get nulls and empties.
How do I prevent nulls AND empties from going forward?
Thanks.

A:

WHERE ISNULL([AddStreet], '') != '';

or even just
WHERE AddStreet != '';

