Kindly assist on the below query
1. Convert all old data (without _N) to _OLD. Example, 000015 to 000015_OLD, same goes for the EmpName table, FURUSAKI to FURUSAKI_OLD
while excluding / ignoring certain character such as '85XXXX', '80XXXX', 'TRXXXX', 'CRXXXX', 'MY', etc
Basically, I wan amend the data with '00XXX' in front only.
2. Convert all new data (with _N) to without '_N'. Example, 000001_N to 000001