Hello

I want to do something like that and I wonder if this works:

I want to set a variable like

SET $MyStartDate$ = 2002-01-01
SET $MyEndDate$ = 2002-03-27

and then the sql server should know that when a query like that comes:

SELECT *
FROM TableXYZ
WHERE Date between $MyStartDate$ and $MyEndDate$

I use a java application that connects to a MS Access database (through jdbc/odbc)
where all queries are already defined. But these queries should contain those
placeholders.

Do you have an idea if this is possible?

Stephan