Search code examples
sqlms-accesssql-likeadodb

ADODB wild card operators other than %

I've seen many questions explaining that the * wildcard character from Access is % when using ADODB. But what about ?, # or the other wildcards and patterns you can use with LIKE in Access? It seems they don't work either over ADODB, do they just have no equivalent?

Solution

  • Match any single alphabetic character:

    ?

    is equivalent to

    [A-Za-z]

    Match any single numeric character:

    #

    is equivalent to

    [0-9]