IFNULL returning NULL when there"s really a value!
am 24.02.2006 05:26:19 von laredotornadoHi,
I have a column SALE_PRICE, which is a FLOAT type. I have a row that
contains the value "0.25", however when I execute this statement
SELECT IFNULL(SALE_PRICE, 'Empty') FROM PRODUCTS WHERE PRODUCT_ID = 2
I get the result "Empty" instead of ".25". Why is that? What can I do
to ensure that I get the value ".25" instead of "Empty"?
Thanks, - Dave