Re: how does NOT work?

On Wed, 2002-04-24 at 17:55, ARP wrote:
> > I guess select count(*) from individu where type2 is null will return 5717 (18417-12619-81)
>
> >Still don't understand the logic - I just want cells that don't start
> >with "a" I don't care if they contain null values or not.

> select count(*) from individu where type2 is null or type2 not like 'a%'

"or" works here but not in some of the more complex joins I am doing
elsewhere. I will be using "-" and "0" a lot more from now on!

Thanks again

Tony

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html