Hi,
I have an smallint variable, say "a", i would like to prefix it with "0" in certain conditions. Is it possible to achieve that with this datatype?
For instance,
a=9 --> a=09
Many thanks
Hi,
I have an smallint variable, say "a", i would like to prefix it with "0" in certain conditions. Is it possible to achieve that with this datatype?
For instance,
a=9 --> a=09
Many thanks
I doubt it would involve storing the number any differently. You may be able to choose the number of leading zeroes in the query.