Is it possible to convert a boolean field to integer? (True = 1, False = 0)
In the following example, "price" is a non-zero numeric field and "status" is a boolean field. So that, when "status=False" then "final_price=0.00" and when "status=True" then "final_price <> 0.00".
SELECT (price * status) AS final_price
I know that I can use a "CASE WHEN..." statement but, in this case, it is not the solution I am looking for.
Regards,
Jorge Maldonado