Hi Michael...

>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

Is the memvar lddate intentionally set to value "%"? That seems to be the obvious problem but something else to consider is the % is a wildcard in SQL Server. So are you saying that you want the ability to use lddate as a specific date -or- wildcard?