Indeed.
Thanks for that! I keep getting bitten by that too hehe.
- Naz.
William Garrison wrote:
My guess is that integer division is to blame: 50 divided by 1500 =
0.03 which rounds to zero. You probably have to cast them to real
before doing the division.
Naz Gassiep wrote:
Is anyone able t
My guess is that integer division is to blame: 50 divided by 1500 = 0.03
which rounds to zero. You probably have to cast them to real before
doing the division.
Naz Gassiep wrote:
Is anyone able to tell me why in the last column of the returned result
set, the value calculated is always 0?
Is anyone able to tell me why in the last column of the returned result set,
the value calculated is always 0?
QUERY:
SELECT products.productid,
products.cost,
products.srp,
CASE WHEN products.srp > 0 THEN (products.srp - products.cost)
