Suppose u have a table named "ADDRESS" AND ITS STRUCTURE LIKE,
ADD1 VARCHAR2(100)
ADD2 VARCHAR2(100)
ADD3 VARCHAR2(100)
EMAIL VARCHAR2(100)
asume that ur table contains the record given below.
ADD1 ADD2 ADD3
EMAIL
Flat 1 Build 1 Road 1
[EMAIL PROTECTED]
Flat 2 Build 2 Road 2
Flat 3 Build 3 Road 3
[EMAIL PROTECTED]
Flat 4 Build 4 Road 4
[EMAIL PROTECTED]
Flat 5 Build 5 Road 5
and if u want to query only the record which is having email (In the above
example 1st, 3rd and 4th record) pls execute the statement below
SELECT * FROM ADDRESS
WHERE EMAIL IS NOT NULL
I think this will sole ur problem
Regards
Abhith. P
Bruce Sorge <[EMAIL PROTECTED]> wrote:
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:2719
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
