I have a Customer ID field that consists of 6 bytes
For example - 15760 , 20, 1420, 186000 and want to change them to the following by adding a leading 0
015760, 000020, 001420, 186000
what function can I use to use this numeric field into a new column as text and add the leading 0's?
Please sign in to leave a comment.