REPLACE ALL costcent2.old_gl_bnk with padl(
alltrim( old_gl_bnk
) ,5,'0')
>I need to alter a numeric table field to be a character field and I want to pad it with leading zeros. I tried the REPLACE ALL but because the length of old_gl_bnk is always the size of the table field, nothing is padded. Any ideas?
>
>ALTER TABLE costcent2 ALTER COLUMN old_gl_bnk C(5)
>REPLACE ALL costcent2.old_gl_bnk with padl(old_gl_bnk,5,'0')
>
>Brenda
Hector Correa