from: Dave <dfx1@xxxxxxxxxxxxxx>
subject: DB2 REGEXP_REPLACE
Been trying for ages to get this right!
SELECT REGEXP_REPLACE(mycolomn, '[0-9,]', 'X' , 1)
Gives me XXX%TM+XXX%BRSS
But I want X%TM+X%BRSS
Is it possible?
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.