Skip to main content
Question

Database package issue

  • May 27, 2023
  • 1 reply
  • 26 views

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

Forum|alt.badge.img+6
  • Navigator | Tier 3
  • 142 replies
  • May 27, 2023

Try this:

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings