Re: sql DELETE FROM with wildcard "%"

I dont tink so, try this

           C/EXEC SQL
           C+ delete from qtemp/tempf1 where ACITY not like :BCITY OR ACITY not 
like '%'
           C/END-EXEC

the caracater  || not is an operator of the sql languaje.

By

On 10/17/06, fkany@xxxxxxxxxxxxxxxxxx <fkany@xxxxxxxxxxxxxxxxxx> wrote:

Hello,

Is this the correct way to write an embedded sql "DELETE FROM" statement
with a wildcard?
==============================================================
           C/EXEC SQL
           C+ delete from qtemp/tempf1 where ACITY not like :BCITY || '%'
           C/END-EXEC
==============================================================

Thanks,

Frank

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.