In my database we scan in serial numbers for tracking. The serial numbers come in with two leading zeros. I created a report for the customer and they want the two leading zeros removed from the serial numbers. How can I create a query that will remove those leading zeros?
Just a caution here. Are you sure there will always only be two zeros that you are dealing with? Generally, in this business, that is not a good assumption. Generally, if what you want is for the leading zeros, that you make sure you are removing zeros, rather than whatever happens to be in the first two positions of the serial number.
If the OP can guarentee that every character in the field contains the digits 0-9 ...
AND the value of the resulting number would not exceed 15 digits (apx precision of a double)
Originally Posted by georgev
then casting the dattype would suffice
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert