Hello I have a table like this:
TBL_TABLE
- ACCOUNT_NUMBER
Now the account number is a string which has 000 in front, some have 3 zeroes and some 5, I'm looking for a query that will remove all the leading zeros. For example record that is like this: 0000898669 would end up being: 898669
I came up with a query like this, but it doesn't remove all zeros, only first 2
UPDATE Table SET ACCOUNT_NUMBER = Mid(ACCOUNT_NUMBER,2,19)
Any ideas ?
TBL_TABLE
- ACCOUNT_NUMBER
Now the account number is a string which has 000 in front, some have 3 zeroes and some 5, I'm looking for a query that will remove all the leading zeros. For example record that is like this: 0000898669 would end up being: 898669
I came up with a query like this, but it doesn't remove all zeros, only first 2
UPDATE Table SET ACCOUNT_NUMBER = Mid(ACCOUNT_NUMBER,2,19)
Any ideas ?