Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trim trailing zeroes
Message
From
25/10/2013 17:07:41
 
 
To
22/10/2013 17:57:06
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:
01586417
Views:
62
Likes (1)
>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

Looks kind of kludgy but......how about

TRANSFORM(INT(myval))+IIF(myval-INT(myval)=0,"",ALLTRIM(TRANSFORM(myval-INT(ab)),'0'))
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform