Hi, I'm wondering if someone can help me out. I've got about 2500 records with serial numbers (stored as text) I would like to update/append.
I want to change the leading 1 in a serial number to a 2 (the length will vary to a maximum of 10 digits). The serial number is stored in the field named SERIAL and in the table named CUST_INF.
Could someone kindly point me in the right direction?