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
how to make ex: 1 look like 000001
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users