Can't comment on limitations of DB2 or DBD::DB2 but lets face it you could do the lcase bit on the bind parameter before the execute using perl string functions. Then the problem goes away.
Ken. -----Original Message----- From: Belinda M. Giardine [mailto:[EMAIL PROTECTED]] Sent: 09 October 2002 20:21 To: [EMAIL PROTECTED] Subject: problem with DB2 and LIKE LCASE (?) When we run a query with syntax like SELECT foo FROM bar WHERE (lower(foo) LIKE lower(?)) from DBI we get the error DBD::DB2::db prepare failed: [IBM][CLI Driver][DB2/LINUX] SQL0418N A statement contains a use of a parameter marker that is not valid. SQLSTATE=42610 The query without the LCASE works SELECT foo FROM bar WHERE (lower(foo) LIKE ?). Is this a limitation of DB2 (it works in Oracle) or is it an error in DBD::DB2? Thanks, Belinda
