Re: DBD::ODBC / ACCESS-SQL incompliancy

[VSarkiss]

You probably have a copy-and-paste error, because even in Access that shouldn't run: you've got an unmatched single quote at the end. You probably meant this:

SELECT * FROM TBLDATA WHERE ([Event Date] LIKE '8/08/2006*');

The question then is, what data type is [Event Date]? If you're storing the date as a string, then you need to match the string format exactly. Otherwise, if you're storing it as a date, you should be able to do it with the funny Access hash-quotes:

SELECT * FROM TBLDATA WHERE ([Event Date] = #8/08/2006#);

If that doesn't work you may want to try canonical ODBC date format: '2006-aug-08'. It's hard to say without knowing more about the database and the code.