Microsoft KB Archive/226119

= INFO: ADO's Find and Filter Support Usage of Wildcards =

Article ID: 226119

Article Last Modified on 5/8/2003

-

APPLIES TO


 * Microsoft ActiveX Data Objects 2.0
 * Microsoft ActiveX Data Objects 2.01
 * Microsoft ActiveX Data Objects 2.1
 * Microsoft ActiveX Data Objects 2.5
 * Microsoft ActiveX Data Objects 2.6
 * Microsoft ActiveX Data Objects 2.7
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.7

-



This article was previously published under Q226119



SUMMARY
ADO's Find method and Filter property both support wildcards.



MORE INFORMATION
ADO's Find method and Filter property both support wildcards to the same degree. They both support "Contains" and "Begins With" usage of wildcards.

For example:


 * example% is supported (begins with):
 * %example% is supported (contains):
 * %example is NOT supported (ends with):

rs.Find "MyField Like 'St%'", 0, adSearchForward, ADODB.adBookmarkCurrent

rs.Filter = "MyField like '%St%'"

rs.Find "MyField Like '%St'", 0, adSearchForward, ADODB.adBookmarkCurrent

