Finding for empty email fields 1

[Jimmy2128]

I am trying to find all our members that has not email address under the email field. I have the following script

select n.id,n.full_name, n.email, n. member_status,n.Member_type, n.company
from name n
where n.email = ''

Would you please tell me if make sense.

Thanks

Jimmy

 

[gmmastros]

It looks ok. I would suggest a small change. email = '' will new return results where the email field is null, so...

select n.id,n.full_name, n.email, n. member_status,n.Member_type, n.company
from name n
where [red]IsNull(n.email, '')[/red] = ''

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom