Rule To Replace Values In SQL When Certain Value Is Found

UPDATE sap_xref
SET ROUTE = REPLACE(ROUTE, ‘EAH_IN’, ‘EAS_IN’)
WHERE ROUTE LIKE ‘SAP_EAH_IN_RFC_%’

Description of the above rules;

sap_xref – SQL table in SI

ROUTE – is the place-holder in table sap_xref

REPLACE – SQL command to perform the conversion

% – wildcard

Leave a Reply

Your email address will not be published. Required fields are marked *

*