-----Original Message-----
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 09, 2004 12:35 PM
To: CF-Talk
Subject: Re: SQL calculating question
SQL *does* deal with decimals - you have to CONVERT or CAST the INT to
REALs first
select CAST(10 as REAL) / CAST(20 as REAL) * CAST(12 AS REAL)
select CONVERT(REAL, 12) * CONVERT(REAL, 10)/ CONVERT(REAL, 20)
Both return 6.0
HTH
Hatton
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
