You can use a CDATA anywhere you like. It might be good to give more context to your question.
Brandon On 4/14/05, Sheehan, Andrew <[EMAIL PROTECTED]> wrote: > 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 '='. >