Here's the code generated by Access for something similar:

SELECT Table1.test
FROM Table1
WHERE (((Table1.test) Like "*05"));

hth,

Doug

"cg" wrote in message
...
Hi All,

I have a table in Access that I am using ADO to connect to in EXCEL. The
table has column headings by month-year (Ex. 01-05,02-05,03-05,04-05,
etc.).

Is it possible to have the SELECT statement use a % wildcard to pull
columns
that end in the year I specify? For instance, if I only wanted to see
2005
data I would have something like this: SELECT [%%-05] From Oracle so that
it
would pull all the columns in the Oracle table that end in 05?

Thanks!!!