RE: SQL Like in jdbc-where-clause

[Halas, Miroslav]

Hi Stephen,

We use starting instead of like
<jdbc-where-clause>where scope starting ?</jdbc-where-clause>
and that works just fine.

-----Original Message-----
From: Stephan Bauer [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 11:51 AM
To: [EMAIL PROTECTED]
Subject: SQL Like in jdbc-where-clause

Hello Jonas-people,

has anyone managed to have a like statement
in his jdbc-where-clause ?

I want to search for all records, where a certain
column starts with a certain letter.

in SQL I'd write:

select * from Address where street like 'A%';

I tried it with:

<jdbc-where-clause>
        <![CDATA[where namePrefix1 like ?% and location like ?%]]>
</jdbc-where-clause>

How do i use the sql-wildcard % 

Many thanks in advance,

Stephan

-- 
_________________________________________________________________________

   Stephan Bauer, Dipl. Inform. (FH)            IT-Freelancer
   Siemensstr. 46                               Tel.:  +49 9421 9749549
   D-94315 Straubing                            Fax:   +49 9421 9749550
   E-Mail: [EMAIL PROTECTED]       Mobil: +49 172  9795002 
   
                        http://www.sportmaschine.de                     
        Sportmaschine.de - das neue, grosse Portal f�r Sportvereine
_________________________________________________________________________
----
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".
----
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".