Searching A Database

Results 1 to 2 of 2

Thread: Searching A Database

  1. #1
    Join Date
    Dec 1969

    Default Searching A Database

    Does Anyone know how to create a Search Within a database, For example The user types in a form the first three letters. Then it finds the closest match within the Database. Please Help

  2. #2
    Michael Thompson Guest

    Default Where STATEMENT

    If you want to search one particular field, You could use a "SELECT...WHERE field1 LIKE &#039%" & strCriteria & "%&#039"<BR><BR>Take the modulus (%) off the front, if you want it to search just the beginning of the field.<BR><BR>There are probably much better ways to do this, but I thought I might offer a simple suggestion.

Posting Permissions

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