Delete rows with string like 'For Del....'

[Former Member]

Hi Experts,

I have been trying to delete rows with 'For Del..." string.

Im using the relational operator 'LIKE'  but SAP does not permit.

Here is my code:

DELETE gt_outtab WHERE name like 'FOR DEL%'.

Any suggestions from the experts group?

Thanks.

[Former Member]

Hi Experts,

I have been trying to delete rows with 'For Del..." string.

Im using the relational operator 'LIKE'  but SAP does not permit.

Here is my code:

DELETE gt_outtab WHERE name like 'FOR DEL%'.

Any suggestions from the experts group?

Thanks.

[Former Member]

Did you try with CS operator or REGEX?

Please search the forum for their usage.

Thanks,

Shambu

[Former Member]

HI Shambu,

does it apply to R3 also.

Thanks

[Former Member]

Yes, Please check for operators in SAP Help(F1).

[kesavadas_thekkillath]

Moderator Message:Unmarked as question. Sounds basic.

Use range tables & in clause with CP option.

Kesav

[Former Member]

This is solved.  Thanks Kesav and shambu