What is the best way to remove leading zeros? For example, an account number could have any number of leading zeros. We need to find the first instance <> 0, then remove any leading zeros to the left of that number. We would like to do this within the INSERT INTO statement for the field name, "LOAN_NUMBER".
Thanks in advance!
Mike
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar