The bigger question may be why you want to bring back all the rows where
certainl columns equal something, such as
where Street_Name = xxxxxxxx
and you also want all the rows where Street_Name is null..
I'm not 100% sure this makes sense, at least to me.. Maybe the original
database design is flawed...


Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>



-----Original Message-----
From: Alexander Tabakov [mailto:saho@...]
Sent: Tuesday, April 08, 2003 10:04 AM
To: Wilson, Fred
Subject: Re[2]: [ib-support] Null values in where clause

>You have to use IS NULL, or IS NOT NULL, such as:
>where Street_Name IS NULL (or where Street_Name IS NOT NULL), for example

I was thinking about this, but I don't know how it would affect
the performance of the query

--
Best regards,
Alexander mailto:saho@...



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=246920.2960106.4328965.1728375/D=egroupweb/S=17051153
86:HM/A=1513703/R=0/*http://www.gotomypc.com/u/tr/yh/cpm/grp/300_06F/g22lp?T
arget=mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=246920.2960106.4328965.1728375/D=egroupmai
l/S=:HM/A=1513703/rand=128949571>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]