PDA

Click to See Complete Forum and Search --> : [RESOLVED] Format Integers

Nate1
05-02-2008, 07:42 PM
I have error records that are numbered based on the Primary key of the database table, I want to display these on screen as instead of 1, 000001, tried the format function but didn't work?

Is there an easy way of doing this with calculating the length of the string?
Nate1
05-02-2008, 07:52 PM
Sorry got it forgot to place SELECT @@IDENTITY in the SQL after the insert

Format(errorID, "0####")