Delete rows from database using a wildcard

[Former Member]

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

[Former Member]

Hi,

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

where fieldname like '58%'.

Thanks,

Sriram Ponna.

[Former Member]

Thanks a lot!