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: arnaud.brion AT panalpina DOT com
******************************************************************************