Removing a decimal from a number
From: <david.skergan_at_cplc.com>
Date: Thu, 18 Feb 1999 16:34:28 GMT
Message-ID: <7ahfek$i0t$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] In a stored procedure, I am trying to read decimal values from a table and [Quoted] [Quoted] export them to a flat file WITHOUT their decimal point.
Date: Thu, 18 Feb 1999 16:34:28 GMT
Message-ID: <7ahfek$i0t$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] In a stored procedure, I am trying to read decimal values from a table and [Quoted] [Quoted] export them to a flat file WITHOUT their decimal point.
For example:
[Quoted] Value: 3.14159 Desired result: 314159
Value: 200.32 Desired result: 20032
[Quoted] What is the best way to do this?
[Quoted] Thanks...
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 18 1999 - 17:34:28 CET