var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.