sql searches

Results 1 to 3 of 3

Thread: sql searches

  1. #1
    Join Date
    Dec 1969
    Posts
    17

    Default sql searches

    i know you can have SQL criteria like "WHERE EmployeeID=whatever" or "WHERE EmployeeID LIKE &#039" & form_EmployeeID & "&#039"<BR><BR>...but is there a way to do searches, or selects, using something like "contains" ? for instance- selecting a record if an ID field contains a certain number; or more specifically- a text field contains a particular word. <BR><BR>Thanks,<BR>Timm

  2. #2
    Shawn Clabough Guest

    Default RE: sql searches

    Depending on the database you&#039re connected to, use "WHERE txtField LIKE &#039%" & strField & "%&#039" or "WHERE txtField LIKE &#039*" & strField & "*&#039"

  3. #3
    Shawn Clabough Guest

    Default RE: sql searches

    Depending on the database you&#039re connected to, use "WHERE txtField LIKE &#039%" & strField & "%&#039" or "WHERE txtField LIKE &#039*" & strField & "*&#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
  •