I have designed a few serial number generators that are still in use. They store the padded number as a string, actually in all cases they also store some other characters. The generating integer is also stored in a separate column. I'd always stick with text for a serial number.