Subject formatting a number
Author Grant Brown
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

Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web :

SiteDoc - Easy to Use - Powerful Results