>>
>>Any example of query that would not work both ways?
>>
>
>Here's a trivial example.
>
>VFP
>SELECT * FROM billing WHERE inv_date = {01/31/17}
>
>SQL Server
>SELECT * FROM billing where inv_date = '2017-01-31'
>

SELECT * FROM billing WHERE inv_date = ?({^2017-01-31})

will work both with VFP tables and cursors, either directly or through SPT, and with any SQL back-end (MSSQL, MySQL, Oracle, ...), won't require any intermediate storage, and will assure that date ambiguity won't occur.