Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim trailing zeroes
Message
From
22/10/2013 18:20:12
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01586185
Message ID:
01586187
Views:
56
>>I'm embarrassed to ask this:
>>
>>I can't figure out how to display a numeric value with the trailing zeroes trimmed. So, if the value is stored in the table as 88.99000, I want the value to display in a report as 88.99.
>>
>>Thanks,
>>
>>Yossi
>
>One possibility
>
>
>alltrim(transform(value), 1, '0') && this will remove trailing zeros but will make this character value
Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform