[Zope] odbc database adapter ... problem with "like"

[Clarence T. Pate]

> |>Use % instead of the asterisk:
> |>where NAME like 'Pate%'
> 
> MS Access in it's infinite wisdom decided to go against the convention of
> using '%' as a wildcard and decided to use '*', so the SQL is correct for
> Access.

>You are of course right concerning Access' use of >wildcards. But in
>ZSQL-Methods only the '%' gives me the expected results - >the '*' as
>wildcard will be ignored. I use Access 97 as database and >ODBC 4.00. 

Thomas,

Thanks!  "%" as the wilcard did the job.

Clarence T. Pate