search form

Results 1 to 3 of 3

Thread: search form

  1. #1
    Omer Guest

    Default search form

    I have a form and i want to search with a wildcard “like”<BR>If I search "de" then I want the results "cdef", "de" ,"def", etc.<BR>How do I achieve this<BR>Regards<BR>

  2. #2
    Eddie Campbell Guest

    Default RE: search form

    Use Like with % marks<BR><BR>MySearchText = "de"<BR>"Select * from MyTable Where MyField Like &#039;%" & MySearchText & "%&#039;"

  3. #3
    omer Guest

    Default RE: search form

    thanx it works

Posting Permissions

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