Add Numbers to Char Data Type

[PNC]

Hi,

I have a field of data type char(16) containing numbers, I want to add "1" to it, but I still want to keep the same format.

SELECT NextStamp, NextStamp + 1
 FROM Defaults
--Returns
0000000000880025	880026
--I want
0000000000880025	0000000000880026

Any ideas on how to do this?

Thanks.

 

[rac2]

SELECT NextStamp,
STUFF('0000000000000000',
      17-DATALENGTH( CONVERT(VARCHAR(16),NextStamp + 1) ),
      16,
      CONVERT(VARCHAR(16),NextStamp + 1)
     )

Forgive me for mentioning this, but it might have been better to store NextStamp as an integer, possibly an autoincrementing or IDENTITY column. Then when the leading zeros are needed for display in an application, make the application responsible for prepending them.

 

[PNC]

You're the man rac2... I know that NextStamp should have been an int, but I didn't develop the database, I'm just the guy who's stuck with the bad design.

Thx.