Results 1 to 2 of 2

Thread: Wildcards

  1. #1
    Mark Guest

    Default Wildcards

    How do I Filter an Access database text field for a sub string? The Filter property only allows the * wildcard at the end of the criterion (according the the ADO help docs and my recent experience)

  2. #2
    Join Date
    Dec 1969

    Default RE: Wildcards

    I have neer been able to get the * to work in Access from an ASP page I use %<BR><BR>Dim MyString<BR><BR>MyString="Find This"<BR><BR>Sql="Select * From Table Where Field1 Like &#039;%" & MyString & "%&#039; ;"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts