[Zope] ZSQL & LIKE Operator

27 Mar 2001

      I'm trying to get Zope to submit a "like" statement to MS Access (please 
don't ask why I'm using MS Access; it's a temporary situation). Anyway, 
I can't get a working ZSQL method LIKE and a wildcard. 

I try:
SELECT *
FROM Cases
WHERE Short_Case_Name LIKE 'Plessy v. Ferguson'
works fine; I try:
WHERE Short_Case_Name LIKE 'Plessy*'
I get no data matching query.

I can run the query through MS Access SQL view just fine; not sure why 
it's not working with ZSQL. 

Donald Braman
donald.braman@yale.edu