Skip to main content
Question

Database package issue

  • May 27, 2023
  • 1 reply
  • 35 views
J
Forum|alt.badge.img+1

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

1 reply

S
Forum|alt.badge.img+6
  • Sumit.K7
  • Navigator | Tier 3
  • May 27, 2023

Try this:

UPDATE [Sheet1$$]
SET Customer = RIGHT(Customer, LEN(Customer) - 3)
WHERE LEFT(Customer, 3) = '000';

Terms & ConditionsCookie settingsAccessibility statement