you could either make that part of your input or you could use
something to the effect of
SELECT
*
FROM device,person
where device.owner = person.regid
<isNotEmpty prepend="AND" property="description">
description like '%' || #description# || '%'
Brandon
.
On 4/13/05, Nic Werner <[EMAIL PROTECTED]> wrote:
> 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 '='.
>
