[Zope] searching names in a query

hi, " Like" in SQL query under Gadfly database doesn't work. Is there any other way by which when give half name all the names related to that should be displayed. eg. *abc* abcde efabcthy Thanks, jacintha