sql question...
From: <oispeggy_at_acsu.buffalo.edu>
Date: 1997/06/12
Message-ID: <Pine.GSO.3.96.970612151549.25962D-100000_at_xena.acsu.buffalo.edu>#1/1
Date: 1997/06/12
Message-ID: <Pine.GSO.3.96.970612151549.25962D-100000_at_xena.acsu.buffalo.edu>#1/1
[Quoted] [Quoted] [Quoted] [Quoted] Learn something new every day....
1.
select lname, fname This returns everyone with 'N' or 'G' or ' '. [Quoted] from resdemo None with 'Y'. None with null.where fellow != 'Y'
2.
select lname, fname This returns only those with null.
from resdemo
where fellow is null
3.
select lname, fname This returns only those with ' '.
from resdemo
where fellow = ' '
[Quoted] [Quoted] What surprised me is that #1 did not return anyone with a null value? [Quoted] I thought it would? Why didn't it?
Thanks,
- Peggy - oispeggy_at_acsu.buffalo.edu