Our customer numbers have gotten a little out of hand (some have leading zeros, wrong sequence number, different lengths etc.) and there doesn't seem to be a method for changing these within HQ or Store Ops. I have prepared a mapped list (old number, new number). Can I just run a SQL update on the CUSTOMER table in HQ and at each store or is there an easier way to change the numbers?
- posted
17 years ago