Redadcting the database...

Need to redact Customers.BANK_ROUTE_TRANSIT & BANK_ACCOUNT_NUMBER
companies.CO_ID.

I'm thinking of redacting them by adding a random digit to each digit in the string. This will create a number that is impossible to trace back to the original number, but will still look like the original number.

Here are the queries I performed:

SELECT C.BANK_ACCOUNT_NUMBER, CEIL(C.BANK_ACCOUNT_NUMBER + (C.BANK_ACCOUNT_NUMBER/10 - C.BANK_ACCOUNT_NUMBER/10 * RAND())) AS GEN FROM CUSTOMERS C;

UPDATE CUSTOMERS SET BANK_ROUTE_TRANSIT = CEIL(BANK_ROUTE_TRANSIT + (BANK_ROUTE_TRANSIT/10 - BANK_ROUTE_TRANSIT/10 * RAND()));

UPDATE CUSTOMERS SET BANK_ACCOUNT_NUMBER = CEIL(BANK_ACCOUNT_NUMBER + (BANK_ACCOUNT_NUMBER/10 - BANK_ACCOUNT_NUMBER/10 * RAND()));

This gave us numbers that still looked real, but weren't. :D