SQLite Forum

Nulls or blanks
Login
Hi

I have a query where i have created a view and i want to extract every personid number where either there is a zero value shown or (I assume) its a null or blank

The following is an example where I would like to get the personid that matches the criteria of either having nothing there or a zero.  So I would like to select 1770, 3090, 15 and 21


PersonID	FatherID	MotherID
2146	        2149	        2148
169	        2157	        2158
1770	        2168	        0
3090	        3789	        0
15		
21		

I have tried to see if they are blanks and I am getting nowhere

Help please

Many thanks

Adrian Mullins