What will be the select request to exclude empty values ​​in ms-access

Question

I'm trying to

select * from table where Contact Is Not null 

but it displays values ​​including empty values

Answer 1

Your query is correct, but you probably have zero rows in the Contact column. you can use

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

The function Nzreturns the specified default value if the column is null.

Answer 2

You can try the following:

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