Return-Path: 
 <ibatis-user-java-return-1828-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 88311 invoked from network); 14 Apr 2005 00:57:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 14 Apr 2005 00:57:03 -0000
Received: (qmail 94621 invoked by uid 500); 14 Apr 2005 00:57:01 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 94592 invoked by uid 500); 14 Apr 2005 00:57:00 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 94577 invoked by uid 99); 14 Apr 2005 00:57:00 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from maggie.sonoma.edu (HELO maggie.sonoma.edu) (130.157.18.54)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 13 Apr 2005 17:56:59 -0700
Received: from [130.157.64.151] (helo=[130.157.64.151])
	by maggie.sonoma.edu with esmtp (Exim 4.30)
	id 1DLsfB-0004l7-PY
	for ibatis-user-java@incubator.apache.org; Wed, 13 Apr 2005 17:56:57 -0700
Message-ID: <425DBFD6.5000902@sonoma.edu>
Date: Wed, 13 Apr 2005 17:56:54 -0700
From: Nic Werner <werner@sonoma.edu>
Reply-To: werner@sonoma.edu
Organization: Sonoma State University
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: ibatis-user-java@incubator.apache.org
Subject: LIKE and Wildcards
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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