Sorry i mean use srpl() to remove the decimal POINT from the string.
 
I pressed send a little too quick.
----- Original Message -----
From: Alan Wolfe
Sent: Wednesday, September 14, 2005 8:32 PM
Subject: [RBASE-L] - Re: Removinf Decimal point from double or currency data types

you could try (maybe with a computed column?) converting the currency to a string and then using srpl to remove decimal places.
 
----- Original Message -----
Sent: Wednesday, September 14, 2005 7:50 PM
Subject: [RBASE-L] - Removinf Decimal point from double or currency data types

Hello List:

 

I have an application that is sending data to a mainframe and the data includes a currency data type.

 

I need to strip out the decimal point from the currency value but still keep the cents

 

Example  $25.45 needs to be 2545

 

Any Ideas or suggestion would be greatly appreciated.

 

TIA

 

Larry Wilson

 

 

Reply via email to