September 25, 2001 at 2:38 pm
Is there a way to automatically add/suppress leading zeros in a numeric column? Any help would be greatly appreciated. Thanks.
September 25, 2001 at 3:38 pm
Not without converting to a string that I can think of. Normally that's what you would do, store as a number, display as a string so you can stick leading dollar sign, zeros, whatever.
Andy
September 25, 2001 at 5:59 pm
You cannot store data with leading zeros into a numeric column. You will have to convert that column into text/varchar to do such operations. Or a better way would be to be add up leading zeros while retriving data (select statements). Use repeat function to carry out such operations.
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
December 5, 2002 at 9:45 pm
quote:
Is there a way to automatically add/suppress leading zeros in a numeric column? Any help would be greatly appreciated. Thanks.
As noted, numeric fields don't have leading zeros. this is an excellent opportunity for a user-defined function.
December 6, 2002 at 7:09 am
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply