Subject RE: [firebird-support] formatting a number
Author Alan McDonald
> 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

there are UDf functions callee PADLeft and PADRight
Alan