what will be the select query for excluding empty values in ms access

Question

I am trying

select * from table where Contact Is Not null 

but it is displaying values including empty values

Answer 1

Your query is correct but probably you have zero length strings in your Contact column. You can use

select * from table where len(Nz(Contact, '')) > 0

The Nz function returns the specified default value if the column is null.

Answer 2

You can try like this:

select * from table where Len([Contact] & "")>0