> 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
