well, it would if we used SQL2000 instead of Oracle :-)
> SQL Question: SQL 2000
>
>Was gonna post this question, but found the answer, so maybe it will help
>someone save some time
>
>The following:
> 1. Select 141/207 returns 0
> 2. Select Convert(float,141/207) returns .00000
>
>This is because SQL does the math first for the division, and apparently
>treats anything less than one as zero, when the dividend and divisor are
>integers.
>
>So you need to do this Select Convert(float,141)/Convert(float,207)
>
>Unless of course the data you are using is already not an integer.
>
>Have a happy day....
>
>John
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
