string..please help!!

Results 1 to 2 of 2

Thread: string..please help!!

  1. #1
    Join Date
    Dec 1969

    Default string..please help!!

    hi,<BR><BR>I have a search facility which searches the database by the entire word rather than sections of those word e.g<BR><BR>if the word were food and I searched it by f, it would yield no results. How can I have it search each alphabet within the database.<BR><BR>This is my current code<BR>sql = "SELECT * FROM types WHERE title = &#039;"& m &"&#039;" <BR><BR>many thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: string..please help!!

    WHERE title LIKE &#039;%" + crit + "%&#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