Where Exists

[has75042]

Hi All,

From the attached file,  I only want to show record that have an email address.

I am using where Exists function and is not working. I am still getting records with doesn't have email address.

Any help would be really appreciate it 

[m_woolf]

Try:

where len(Email)>0

[Jacek]

Function EXISTS refers to data reloaded before this table. Please use: where len(trim(Email))>0 or where not isnull(Email)