Hi Oscar,

The 'Null' represents unknow value therefor ? Null = Null returns .F. You can use IS NULL SQl Select operator.

Where myfield IS NULL

>I need to retrieve records where a certain field contain a null value, or is empty. These records are empty because a column was added. Some of this new fields contain data but I need to retrieve only those empty. A VFP remote view shows null, but when I execute a query through SQLEXEC, the where statement does not accept
>
>Where field = .Null.
>Or
>Where empty(field)