Using a like statement

[Steven Pannell]

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.