Jacintha, This is from the Gadfly SQL support page at: http://www.chordate.com/kwParsing/gfSQL.html ***** Some important omissions from ODBC 2.0 at this point are Nulls. Outer joins. CHECK conditions. Enforced data type constraints. Alter table (can't implement until NULLs arrive). Date, Time, and Interval data types It is hoped these will be implemented at some future time. Less important omissions include Cursor based updates and deletes (justification: if you really need them the db design is flawed, and it's possible to use python instead). LIKE string predicate (justification: use Python regexes in python code). Users and permissions (justification: Gadfly is not intended for full multiuser use at this time). ***** Note that Gadfly does not support LIKE. They suggest that you use regexes in python code. I may be totally wrong, but in order to do this, you must use external methods. Anyone know better? Troy -----Original Message----- From: jacintha menezes [mailto:jacintha.menezes@wipro.com] Sent: Friday, January 19, 2001 6:02 AM To: ethan mindlace fremen; Tim Cook; Graham Chiu; ethan mindlace fremen; Dieter Maurer; Daniel Rusch; Cornelis J. de Brabander Cc: zope@zope.org Subject: [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 _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )