this case statement does not return the result i'm expecting
the value of wq.quantity_on_hand = 156, im.last_repack_item = 0, im.freight_item = .38010
( Case when im.last_repack_item = 0 then wq.quantity_on_hand * ( im.last_repack_item + im.freight_item ) else 0 END ) repack_cost,
the select returns 59.2956 (156 * .38010) i thought it should return 0
i've worked around it by creating multiple columns, but i'd like to know if it's a bug, or if it's the way it's supposed to work.
thanks Tom M.