topic Re: Delete rows from database using a wildcard in Application Development and Automation Discussions

Delete rows from database using a wildcard

Former Member — Tue, 18 Dec 2007 10:56:23 GMT

Hi all,

I would like to delete rows from a database table using a wildcard, e.g.

DELETE FROM /BIC/AFBC01_O6

WHERE /bic/zcs_item = '58%'.

So I want to delete all items starting with '58', but it doesn't work. Although there are existing entries starting with '58', sy-subrc is 4. Does anyone have a clue what I'm doing wrong?

Thanks and best regards,

Markus

Re: Delete rows from database using a wildcard

Former Member — Tue, 18 Dec 2007 11:01:24 GMT

Hi,

If you are using wild cards in the statement you always use as below :

where fieldname like '58%'.

Thanks,

Sriram Ponna.

Re: Delete rows from database using a wildcard

Former Member — Tue, 18 Dec 2007 11:07:34 GMT

Thanks a lot!