Jump to content


This topic is now archived and is closed to further replies.


how to make ex: 1 look like 000001

Recommended Posts


I'm coding a serial system for the firm I'm working for.

We want to implement our own serial number to some items and we want to name the products like:

CM-000001, CM-000002 and so on.

I'd like to know how we can keep a number in 000001 format in the database?

It's MS SQL Server. I tried to change the precision and etc after making the field as decimal but didnt work.

Any help will be appriciated? Thanks

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.