I remember from a few years ago, I was told on this list, that the next MaxDB version (7.6) would allow to use like with long columns.
When I try now something like: select * from egw_cal where cal_description like '%test%' * -7032: POS(29) SQL statement not allowed for column of data type LONG SQLSTATE: I7032 It seems not the case. Or do I have to cast the column to varchar before? Ralf -- Ralf Becker eGroupWare Training & Support ==> http://www.egroupware-support.de Outdoor Unlimited Training GmbH [www.outdoor-training.de] Handelsregister HRB Kaiserslautern 3587 Geschäftsführer Birgit und Ralf Becker Leibnizstr. 17, 67663 Kaiserslautern, Germany Telefon +49 (0)631 31657-0 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]