of course that was where email IS NOT NULL
On 2/7/07, Jerry Johnson <[EMAIL PROTECTED]> wrote: > > 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:2717 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
