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

ID: Q226119


The information in this article applies to:
  • ActiveX Data Objects (ADO), versions 2.0, 2.01, 2.1
  • Microsoft Data Access Components versions 2.0, 2.1


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
    © 2000 Microsoft Corporation. All rights reserved. Terms of Use.