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