Another option is to use SET FMTONLY ON before running your query. Only the format of the result set will be returned. The query will not be processed.

-Mike

>I would like to use SQLExec() to return empty record. In VFP, I would simply do:
>
>

>SELECT * FROM News WHERE .F.
>

>
>but, from VFP, to query from a SQL Server table, doing this:
>
>

>SQLExec(lnHandle,'select * from dbo.News where .f.')
>

>
>returns all the records. What is the proper syntax to use?