Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to output zerofilled text from query of numeric f
Message
From
13/05/2003 08:59:19
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
13/05/2003 08:38:39
Robin Lampron
NH Environmental Services
Concord, New Hampshire, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Trying to output zerofilled text from query of numeric f
Miscellaneous
Thread ID:
00787664
Message ID:
00787676
Views:
13
Hi Robin,

TRANSFORM(pnlty_amt,'@L 9999999.99')

or faster, more rigid,

PADL(LTRIM(STR(pnlty_amt,9,2),9,'0')


Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform