>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
Try REPLACE ALL costcent2.old_gl_bnk with padl(ALLTRIM(old_gl_bnk),5,'0')