Subject | formatting a number |
---|---|
Author | Grant Brown |
Post date | 2005-04-27T05:38:52Z |
Hi all,
In FB1.5 how can I format a number into a string with a fixed number of
leading zeros inside of a stored procedure ?
for example if the number is 10 then after formatting it would be a
string with a value of 0000010
thanks in advance
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results
In FB1.5 how can I format a number into a string with a fixed number of
leading zeros inside of a stored procedure ?
for example if the number is 10 then after formatting it would be a
string with a value of 0000010
thanks in advance
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results