Hi all;

I'm working with VC++ OLEDB ADO connecting to an Access database, my problem is in the Query I have wildcards with a LIKE statement but either OLEDB is not passing wildcards or Access ignoring the wildcards in a LIKE statement.

This will work and find only exact part number input.
sprintf(szPartial, "SELECT * FROM [parts] WHERE [partno] LIKE '%s'", (LPCSTR)csInput);

This will NOT (added * to like statement) work and find NO part number matches from input.
sprintf(szPartial, "SELECT * FROM [parts] WHERE [partno] LIKE '%s*'", (LPCSTR)csInput);

I have viewed the "szPartial" string in the debugger and all the char's are there, there is no stripping of char's in the sprintf function.

Neither VC++ or OLEDB/Access kicks up a syntax error or any error at all they just seem to ignore any wildcards in the SQL statement.

Has anyone seen this kind of problem from OLEDB ADO?

Thanks in advance

J.R.

Hi All;

After much research and trial and error I think I have found the problem, it looks as though there was a change in the Wildcard syntax between Jet 3.51 and Jet 4.0. So if you use the datasource connection of "Provider=Microsoft.Jet.OLEDB.4.0;" you must use the SQL Server syntax for the wildcards (%_) and under "Provider=Microsoft.Jet.OLEDB.3.51;" you must use the "older" style wildcards (*?).

Hope this helps someone else...

J.R.

That is helpful. I have been trying to figure this out since I started using Access 2000. I switched back to using DAO when ever I needed to use LIKE because I was never getting any results. I will try the different syntax.

Thanks for the Info!!!