[RBASE-L] - RE: Removinf Decimal point from double or currency data types

[Javier Valencia]

Larry: Create a view as follows: CREATE VIEW `your_view` AS  + SELECT (INT(your_money_col * 100)) FROM your_table   This will create a view with your currency column displayed as cents with no delimiter; i.e. $25.45 will be displayed as 2545 Of course you can have your other columns as part of the view as well. Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Larry Wilson Sent: Wednesday, September 14, 2005 9:51 PM To: RBASE-L Mailing List 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