Re: SQL calculating question

[C. Hatton Humphrey]

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]

---