db search

Results 1 to 2 of 2

Thread: db search

  1. #1
    Russel Guest

    Default db search

    I need to find a post where two variables are correct.<BR><BR>I uses Access.<BR>Can I write something like<BR>Select * FROM table WHERE name LIKE "Russel" & town LIKE "%town"<BR><BR>Or is it some other way to solve my problem?

  2. #2
    Join Date
    Dec 1969

    Default RE: db search

    Should be...<BR><BR>Select * FROM table WHERE name LIKE &#039Russel&#039 & town LIKE &#039%" & town & "&#039"<BR><BR>(assuming town is a variable holding some value)<BR>

Posting Permissions

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