LIKE operator not working

Results 1 to 2 of 2

Thread: LIKE operator not working

  1. #1
    Join Date
    Dec 1969

    Default LIKE operator not working

    I am using a LIKE statement in a fairly simple SQL statement it will work in access but not when i run it through PWS. There are tons of other SQL statements in the site I am writing but there seems to be no problem with these! <BR>basically i am writing <BR>SELECT * FROM tblWhatever WHERE surname LIKE &#039*" & myVariable & "*&#039"<BR>can anybody help me?

  2. #2
    Join Date
    Dec 1969

    Default RE: LIKE operator not working

    Use "%" instead of "*"...weird but true.<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