Re: SQL Like in jdbc-where-clause

[Calvin Varney]

Or you could use:

<jdbc-where-clause>where upper(namePrefix1) like &apos;%&apos; +
upper(?) + &apos;%&apos; and  upper(location) like &apos;%&apos; +
upper(?) + &apos;%&apos;</jdbc-where-clause>


----- Original Message -----
From: "Stephan Bauer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 27, 2001 5:16 AM
Subject: Re: SQL Like in jdbc-where-clause


> Hi all,
>
> I just managed it by myself.
>
> I left the jdbc-where-clause in it's standard form
> <jdbc-where-clause>
> where namePrefix1 like ? and location like ?
> </jdbc-where-clause>
>
> but I appended the SQL-Wildcard % to the substring, for
> which i am searching in the Java-Code, so
> that the parameters of the finder-Method have the % in them.
>
> Bye,
>
> Stephan


----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".