It is in the FAQ: http://opensource.atlassian.com/confluence/oss/display/IBATIS
Larry On 5/31/05, Steven Pannell <[EMAIL PROTECTED]> wrote: > Hi, > > Is there an easy way to describe a 'like' statement in the iBatis xml file. > for example I have: > > <select id='dd' parameter="string"> > select * from bush where bush_name like #value# > </select> > > Using Oracle I have to make the value look like this: > > String value = "hello%" > > Can't I do this in the map something like: > > > <select id='dd' parameter="string"> > select * from bush where bush_name like #value#% > </select> > > > At present this won't work. > > cheers, > Steve. >