That did the trick. Thanks. Bruce Sorge ----- Original Message ---- From: Ray Thompson <[EMAIL PROTECTED]> To: SQL <[email protected]> Sent: Wednesday, February 7, 2007 10:35:44 AM Subject: RE: Filtering Records
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:2718 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
