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

ID: Q226119

The information in this article applies to:

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):
    • 
rs.Find "MyField Like 'St%'", 0, adSearchForward, ADODB.adBookmarkCurrent


  • %example% is supported (contains):
    • 
rs.Filter = "MyField like '%St%'"


  • %example is NOT supported (ends with):
    • 
rs.Find "MyField Like '%St'", 0, adSearchForward, ADODB.adBookmarkCurrent

    © Microsoft Corporation 1999, All Rights Reserved.
    Contributions by Matthew Hofacker, Microsoft Corporation


    REFERENCES

    Microsoft Data Access SDK

    Additional query words: 

    
Keywords          : kbADO kbMDAC kbGrpVBDB 
Version           : WINDOWS:2.0,2.01,2.1
Platform          : WINDOWS 
Issue type        : kbinfo

    Last Reviewed: May 3, 1999