Re: Prepared Statements

Is it possible to code a PreparedStatement that will do a successful select
using LIKE where the ? comes between % and %?  This are the options I have
thought of:

"SELECT ART_SEQ, ART_FORTE FROM ARTISTS WHERE ART_NAME LIKE '%?%';
or
"SELECT ART_SEQ, ART_FORTE FROM ARTISTS WHERE ART_NAME LIKE '%'?'%';
or
"SELECT ART_SEQ, ART_FORTE FROM ARTISTS WHERE ART_NAME LIKE %?%;

I don't know exactly how the substitution works for the ?, but all of these
options seem unlikely.  Maybe I'm going to have to resort to a plain
Statement.

Any comments?
--
Dale Erwin
Salamanca 116
Pueblo Libre
Lima 21 PERU
Tel. +51(1)461-3084
Please note that gmail does not accept executable files as attachments,
including .cmd files, even if they are archived in a .zip file.  They
must be renamed changing the extension



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642