INFO: ADO's Find and Filter Support Usage of Wildcards (226119)

The information in this article applies to:

ActiveX Data Objects (ADO) 2.0
ActiveX Data Objects (ADO) 2.01
ActiveX Data Objects (ADO) 2.1
ActiveX Data Objects (ADO) 2.5
ActiveX Data Objects (ADO) 2.6
ActiveX Data Objects (ADO) 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

REFERENCES

Microsoft Data Access SDK

Modification Type:	Major	Last Reviewed:	5/8/2003
Keywords:	kbinfo KB226119