> integer) is < 1 then SQL Server keeps the variable definition
> at integer and spits out the integer value of the result,
> which is 1. Same thing with your convert(float, 141/207).
> It does the integer division which returns a 0 and then
> converts 0 to a float.
Correction to my explanation, the integer result is 0, not 1 (*oooooops*)
Hatton
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
