not case sensitve search in DB2

2003-08-14 Thread Matthias . Roth
Hi, has some body made an SqlGenerator Class that generates a where claus like this: select x,y,z from a where upper(z) like upper(?) this is helpful if the database like claus is case sensitiv, like in oracle or db2. regards Matthias Roth

RE: not case sensitve search in DB2

2003-08-12 Thread Bram Meijboom
-- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 5:16 PM To: [EMAIL PROTECTED] Subject: not case sensitve search in DB2 Hi, has some body made an SqlGenerator Class that generates a where claus like this: select x,y,z from a where upper(z) like upper(?) this is hel