Which wildcard should I use to run query in ADO? 2

[surotkin]

Hi everyone,
does anybody know what wildcard should I use to run query in ADO to substitute wildcard "?" (Any single character).

I use character "%" to substitute wild-card "*" (Zero or more characters).

What about wildcard "?" (Any single character)

surotkin

 

[cmmrfrds]

Did you try the underscore "_

 

[Zion7]

Just to "Underscore", cmmrfrds' suggestion...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima0601.asp

...good luck!

 

[surotkin]

Hi Cmmrfrds and Zion7,
thanks for your responces.

It works!

I also checked the link provided by Zion7.
It is great that I can run queries with ADO-wildcards in MS Access by using operator ALIKE instead of LIKE.

Thank you very much.
surotkin