Odd query result

[Paradigm]

I have a query
SELECT * FROM mydata WHERE mydata.Status<>"S"
The problem is it also filters out all data where the status is blank or
null
Alec

 

[Gijs Beukenoot]

From Paradigm :

I have a query
SELECT * FROM mydata WHERE mydata.Status<>"S"
The problem is it also filters out all data where the status is blank or
null
Alec

Try
SELECT * FROM mydata WHERE Nz(mydata.Status,"")<>"S"