Oh you may have to use this if the field has null values. Where Len(LTrim(RTrim(IsNull(EmailAddress,'')))) > 0
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 1:34 PM To: SQL Subject: Filtering Records Hello, I need to query a database for email address, but I only want those records that have an address entered in it since in this table Email is not required. How do I do the SQL query for that? I tried WHERE LEN(EmailAddress) but that did not work. Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2715 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
