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

    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
    FROM PRSN
    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
    thanks!

    EDIT: oops! nevermind i just figured out you're supposed to use * instead of a %
    doh
    Last edited by RedSweaterBoy; 02-07-04 at 01: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
  •