UPDATE BANCO
SET DSARQBOLCOMPMOBI = TRIM(REPLACE(upper(substr(DSARQBOLCOMP,INSTR(DSARQBOLCOMP,  '\', -1)+1,length(DSARQBOLCOMP))),'.QR2',' '))||'.rptdesign'
WHERE DSARQBOLCOMP  IS NOT NULL
/

COMMIT
/