Using the Like statement

Results 1 to 2 of 2

Thread: Using the Like statement

  1. #1
    Join Date
    Dec 1969

    Default Using the Like statement

    I am currently using the LIKE statement to search a database, and it returns any occurance of the word in any part of any word in the selected field. Example:<BR><BR>SQL = "Select * From Table Where Product Like &#039;%" & variable & "%&#039;" <BR><BR>So if I search for the word "cat", I end up getting things like eduCATion pendant, etc. Is there a way to use the LIKE statement and only return if the whole word is in the field?<BR><BR>Any help would be appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: Using the Like statement

    take out the wildcards<BR>(%&#039;s)

Posting Permissions

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