MS Access query with wildcard using PHP and MS ODBC

Note: I first posted this in the MySQL forum by mistake, forgive the double post.

I've an issue I cannot seem to figure out. I am attempting to query an Access database using PHP. The db is Access 97. The server is MS 2000 server. I am using MS Access ODBC. The query should return any rows that match the ServiceKey and days that are in March.

My query is about like this:

"select UseDate,Quantity from tblUseSummary where ServiceKey=$servicekey and UseDate=3/%/2003"

I have also tried the same query as above only using "UseDate like 3/%/2003" and where I use other wildcards such as the * and ?.

I will recieve an error of "Missing Operator" or "Syntax error" depending on the combination of = or like and * or ? or %.

Where should I go with this?

if 3/%/2003 means any day in march 2003,

where .... year(UseDate)=2003 and month(UseDate)=3


rudy

Thank you very much. This is exactly what I needed. All is well and I can go home for the weekend now.