Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
where len(Email)>0
Function EXISTS refers to data reloaded before this table. Please use: where len(trim(Email))>0 or where not isnull(Email)