integer with leading zeros

Question

i have an msAccess db that i need to move over to msSQL2000
and a numeric field of part numbers always has 5 digits: example:
12345, 01234, 00123....

in msAccess the field data type is "number" with a format of
"00000" which maintains leading zeros.

problem is that i cannot figure out to create an equivilant
numeric field that maintains leading zeros in msSQL2000. would
prefer not to use "char"

thanks in advance

Newsgroup_User · Answer

ranger wrote:> in msAccess the field data type is "number" with aformat of "00000" which > maintains leading zeros.no, it only displays it that way.> problem is that i cannot figure out to create anequivilant numeric field that > maintains leading zeros in msSQL2000. would prefer notto use "char"you can't. either you format on the fly in sql server(complicated) or you format (numberFormat(), etc.) it in cf.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded