CFLDAP filter for NULL value CFLDAP filter for NULL value KevinFSI (Programmer) (OP) 18 Sep 06 16:07 Is there an equivilant to IS NOT NULL using CFLDAP filters?I want to return a list of LDAP entries, but I want to exclude records where there is NOT an e-mail address.I tried: !(mail=NULL)!(mail=NUL)!(mail=\00)!(mail='') RE: CFLDAP filter for NULL value ecobb (Programmer) 18 Sep 06 17:16 I have no clue if this will work or not, I haven't fooled with LDAP in a couple of years, but have you tried:CODEfilter="mail IS NOT NULL"or filter="mail <> '"Unless you're returning A BUNCH of records with NULL emails, I wouldn't worry about it. Just pull back the info, then let CF sort through whether or not they're NULL. Hope This Helps!ECARECAR Technologieswww.ecartech.com"My work is a game, a very serious game." - M.C. Escher RE: CFLDAP filter for NULL value KevinFSI (Programmer) (OP) 18 Sep 06 17:18 Thanks for the response. Actually, I figured out if I put FILTER="mail=*" it will ignore empty strings and nulls. So, it's a backwards way of doing it (at least I feel like it is) but it works.