Re: [Zope] ZSQL & LIKE Operator

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.

Try: WHERE Short_Case_Name LIKE 'Plessy%' Dimitris @ Nuclear