Posted by laredotornado on 02/24/06 06:26

Hi,

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

• Next in forum: Re: phpMyAdmin : convcharset, utf8 and iso-8859-15
• Prev in forum: Re: Possible to copy data and update a field at the same time?
• Thread view: IFNULL returning NULL when there's really a value!

[Reply to this message]