Int value as 0001
Database
2
Posts
2
Posters
0
Views
1
Watching
-
How can i crate aint value that will display the value as 0001 to 9999 without omitting the zeroes Thanks javierarka
-
How can i crate aint value that will display the value as 0001 to 9999 without omitting the zeroes Thanks javierarka
In SQL-Server:
set @myString = Right('0000' + Convert(varchar(4), @MaxKey), 4)
In VbScript:myString = Right("0000" & intNumber, 4)