Hi gang, Like many others here, I'm fighting against the real DB2 world SQL syntax, and am totally unable to get a working equivalent of that query (simplified for demo purposes) :
select * from summary where entity like upper(%'$1'%) Did anyone succeed in having such one working in 6.2 ? Thanks for your help ! Cheers. Arnaud ****************************************************************************** Corporate IT Systems & Datacenter Responsible Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [email protected] ******************************************************************************
