Subject CORRECTION Re: [firebird-support] formatting a number
Author Helen Borrie
Oh the woes of lifting sidenotes!!

PADDED_STRING = CAST(YourInteger AS CHAR(10));
WHILE (NOT (PADDED_STRING LIKE '__________%'))
DO
PADDED_STRING = '0'||ID_AS_STRING;

/* :-( */

./heLen