Re: how does NOT work?

> 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.

Your answer is :

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

otherwise you trash the null values as you said :-)

Arnaud