Re: LIKE and Wildcards

[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

Re: LIKE and Wildcards

, 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

Re: LIKE and Wildcards

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

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

Re: LIKE and Wildcards

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