LIKE operator

Results 1 to 2 of 2

Thread: LIKE operator

  1. #1
    Join Date
    Dec 1969

    Default LIKE operator

    "SELECT * FROM user WHERE surname LIKE &#039;%" & surname & "%&#039; "<BR>This should bring up the results from what was typed in, in the surname field. If "a" is submitted it brings up results beginning with "a" and also "kar" im not sure why. Is there something wrong with my LIKE statement

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default That is how it works

    if you want it to bring up results BEGINNING with a then your SQL should be like<BR><BR>"SELECT * FROM user WHERE surname LIKE &#039;" & surname & "%&#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