[Zope] ZSQL & LIKE Operator

[Dimitris Andrakakis]

> 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