maybe where email is null
? On 2/7/07, Ray Thompson <[EMAIL PROTECTED]> wrote: > > Try: > > Len(Ltrim(RTrim(EmailAddress))) > 0 > > In the where clause. > > 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:2716 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
