0

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?

cheezsteak
  • 2,731
  • 4
  • 26
  • 41
  • 3
    See [Access wildcard character reference](https://support.office.com/en-us/article/Access-wildcard-character-reference-AF00C501-7972-40EE-8889-E18ABAAD12D1) for explanation of wildcard differences between ANSI-89 and ANSI-92 query modes. – HansUp Aug 25 '16 at 16:23
  • Just a general translation from Access LIKE patterns to ADODB LIKE patterns which seems to be ANSI-89 to 92. That link is basically the answer, @HansUp. – cheezsteak Aug 25 '16 at 16:48
  • 1
    OK. Also see whether you like `ALike`: [Microsoft Jet wildcards: asterisk or percentage sign?](http://stackoverflow.com/a/720896/77335) – HansUp Aug 25 '16 at 16:51

1 Answers1

0

Match any single alphabetic character:

?

is equivalent to

[A-Za-z]

Match any single numeric character:

#

is equivalent to

[0-9]
onedaywhen
  • 55,269
  • 12
  • 100
  • 138