Hiya, Would you be able to use a CDATA section in your where clause?
HTH, Andrew -----Original Message----- From: Nic Werner [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 8:57 PM To: ibatis-user-java@incubator.apache.org Subject: LIKE and Wildcards Hi again, Is there a way to use the 'like' operator and also use wildcards? I'm trying to use Oracle with this, and the following does not work: SELECT * FROM device,person where device.owner = person.regid <isNotEmpty prepend="AND" property="description"> description like %#description#% (I get invalid symbol) All examples only use the equivalent of #description# which doesn't add anything of value, it is the equivalent of using '='.
