Hi Sergey

Thanks a lot one more time.

I bet you are one of the top message posters.

BTW, where could I find what clauses and functions can be used as part of a SQL statement for SQL-server?

Any reference to online information on MSDN, KB, Wwhite papers?, etc?


Oscar


>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)