You can't use SQL wildcards with =, you need to use LIKE. Try this:

SELECT *;
 FROM dbo.Test Test;
 WHERE Test.date1 LIKE ?lddate

I'm pretty sure you can do this in SQL Server. It won't work as a VFP query because VFP can only use wildcards with text data.

>I get this error ("Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting DATETIME from character string.") in a remote view with the following code. ldDate is equal to '%'. Seems simple enough but here we go again. Can anyone help?
>
>SELECT *;
> FROM dbo.Test Test;
> WHERE Test.date1 = ?lddate