>The correct SQL syntax is usually :
>
>SQLEXEC(1,'SELECT bbjthead where closedate is null','test')
>
>SQL Server/Oracle

Thanks. That worked.

Now I'm trying to test for and empty date time field
and getting a -1 on the SQLEXEC()

SQLEXEC(1,'SELECT bbjthead where closedate is null OR closedate ={}','test')

Once I get that I will test for clsedate is null Or closedate={} and
the same 2 possible conditions for another field cancldate

SQLEXEC(1,'SELECT bbjthead where (closedate is null OR closedate ={}) AND(cancldate is null OR cancldate ={}) ','test')

Along those lines is it possible to open a SQL Database and use the
Query build native to FoxPro to build queries then edit them later?