Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER n(7) to c(6) and pad with leading zeros
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: ALTER n(7) to c(6) and pad with leading zeros
Miscellaneous
Thread ID:
00529975
Message ID:
00529977
Views:
11
This message has been marked as the solution to the initial question of the thread.
>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')
Previous
Reply
Map
View

Click here to load this message in the networking platform