Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Toronto,ON Canada Eh?

    Question Unanswered: Using "LIKE" in an Access 2000 SQL statement

    hi everyone.. i'm pretty new with using Access so please bear with me

    does Access not like using "LIKE" in an SQL statement?

    i was trying out the query below to look for last names containing the substring 'pa' on my PRSN table

    SELECT PRSN.IntnId, PRSN.LastName, PRSN.FirstName
    WHERE PRSN.LastName LIKE '%pa%';

    does Access treat the '%' as part of the string it's looking for?

    i also tried adding ESCAPE '\' to the statement and placing the backslash before each '%' with no luck

    any help is appreciated

    EDIT: oops! nevermind i just figured out you're supposed to use * instead of a %
    Last edited by RedSweaterBoy; 02-07-04 at 00:19.

Posting Permissions

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