Hi!

I have a query:

SELECT * From
OPENROWSET(MyLinkedServer, 'SELECT * FROM tblMyTable WHERE MyField > 01/01/2000')

I run this query for Access databsae. Now I need to replace 01/01/2000 by variable passed to the query, for example:

select @MyVar = '01/01/2000'
SELECT * From
OPENROWSET(MyLinkedServer, 'SELECT * FROM tblMyTable WHERE MyField > ' + @MyVar)

Above does not works, says 'incorrect syntax near '+' '

I cannot use
SELECT * From MyLinkedServer...tblMyTable WHERE MyField > @MyVar

because it queries all rows from linked database table, that is quite large and I want to filter out records just before SQL Server receives result. This have strange performance reasons.

Who knows any workaround?