UPDATE [Sheet1$$]
SET Customer = IIF(Customer LIKE '000%', SUBSTRING(Customer, 4), Customer)
WHERE Customer LIKE '000%';
Why this query is not working?
| Customer |
| 0001645445 |
| 0001026470 |
| 1645338 |
| 1645338 |
| 0001022163 |
| 1645426 |
| 1645338 |
| 1645370 |
Database package issue
+1
Try this:
UPDATE [Sheet1$$]
SET Customer = RIGHT(Customer, LEN(Customer) - 3)
WHERE LEFT(Customer, 3) = '000';
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.