Jump to content


Photo

how to make ex: 1 look like 000001


  • Please log in to reply
1 reply to this topic

#1 NorthWind

NorthWind
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 16 May 2006 - 02:21 AM

Hello

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

#2 NorthWind

NorthWind
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 17 May 2006 - 06:36 AM

solved this by coding php to do it for me!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users