Having recently tried to use wildcards in SQL statements with ADO, I realised I had a problem.

Thanks to this forum I found out that the wildcards have different characters for use in ADO than in MS Access.

Instead of using * you should use % with ADO.
Also, instead of using ? you should use _ with ADO.

You can use a whole host of other wilcard characters, such as [A-D] (meaning a letter from A to D). This works just the same in ADO as MS Access.

What I want to know is if there are any other changes, any other wildcards which are different from ADO to MS Access.

Please can people list wildcards I have missed, and their relevant characters for use with ADO.

For some reason this information doesnt seem to be documented anywhere other than this forum!