Convert value from -00005.55 to -5.55

akbar2002 · Post by **akbar2002** » Sat Nov 20, 2010 6:30 am

ray.wurlod wrote:Did you mean DecimalToString() ?

Yes, made a typo.

Sorry about that
SV1 : DecimalToString(column_name) --> DataType = VarChar
SV2 : Field(SV1,'.',1) --> DataType = Integer
SV3 : Right(SV1,2) --> DataType = VarChar

Derivation : SV2:'.':SV3 --> DataType = VarChar

prasad.bodduluri · Post by **prasad.bodduluri** » Thu Dec 02, 2010 2:43 am

you can use fix function

naveen.p · Post by **naveen.p** » Mon Dec 06, 2010 12:11 am

Hi,

You can use DecimalToString(<Column_Name>,"suppress_zero").

Naveen