|
Yes, Use DIGITS(num1) Instead of CAST() Charles > -----Original Message----- > From: Lim Hock-Chai [mailto:Lim.Hock-Chai@xxxxxxxx] > Sent: Thursday, May 20, 2004 10:01 AM > To: Midrange Systems Technical Discussion > Subject: SQL cast(Num1as char(5)) > > > Is there a way to keep the leading zeros when casting a > numeric field to char? > Example: > If Num1 has a value of 23, I would like the casted result > to be 00023. > > thanks > _______________________________________________ > This is the Midrange Systems Technical Discussion > (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.