LIKE and Wildcards

[Nic Werner]

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 '='.