[Zope] ZSQL "OR" search help

[Fabrizio]

Hello,

How can I perform a "OR" search on a SQL database field using a web form ?


E.g. :

I have a SQL database table with fields "name", "surname" and the following
records:


Jimmy    Carter
Ronald    Reagan
George   Bush
Bill           Clinton

I would like to search the "name" field through a web form and write :

George OR Jimmy


And it should return :

Jimmy      Carter
George    Bush



Thanks for your help.


Fabrizio C.