Hi, there are several possibilites to solve your problem: Here are some examples: D HstName S 50A varying D HstNameFix S 50A *------------------------------------------------------ C Eval HstNameFix = '%Media%' C/Exec SQL C+ Delete from MyTable C+ Where Name Like Trim(:HstNameFix) C/End-Exec C Eval HstName = '%Meier%' C/Exec SQL C+ Delete From MyTable C+ Where Name Like :HstName C/End-Exec C Eval HstName = 'Miller' C/Exec SQL C+ Delete From MyTable C+ Where PosStr(Name, :HstName) > 0 C/END-EXEC C Eval HstNameFix = 'Brown' C/Exec SQL C+ Delete From MyTable C+ Where PosStr(Name, Trim(:HstNameFix)) > 0 C/END-EXEC Hope this helps. Mit freunlichen Gruessen / Best regards Birgitta Hauser"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)----- Original Message ----- From: <fkany@xxxxxxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx> Sent: Tuesday, October 17, 2006 16:23 Subject: sql DELETE FROM with wildcard "%"
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.