https://community.sap.com/t5/technology-q-a/hana-ifnull-function-doubt/qaa-p/456003#M70907 <P>Once the column STD1 is flagged as "NOTNULL" the actual value in it is empty not null. That's the reason why the function is not working in this case.</P> Thu, 25 May 2017 18:40:26 GMT former_member280546 2017-05-25T18:40:26Z https://community.sap.com/t5/technology-q-a/hana-ifnull-function-doubt/qaq-p/456002 <P>I don't know if I understand the IFNULL function correctly but it seems that it is not working properly.</P><P>Here is my select statement:</P><P><STRONG>SELECT</STRONG> LIFNR,<STRONG>IFNULL</STRONG>(STCD1,STCD2),STCD1,STCD2 <STRONG>FROM</STRONG> LFA1 <STRONG>WHERE</STRONG> "LIFNR" = '0009009005'</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/35446-captura-de-tela-2017-05-22-as-153205.png" /></P><P>I would like to return the STCD2 value if STCD1 is null. In this sample the STCD1 is null and the function is not returning STCD2.</P><P>Am I missing anything?</P><H2>Syntax</H2><PRE><CODE> IFNULL (expression1, expression2) </CODE></PRE><H2>Description</H2><P>Returns the first not NULL input expression.</P><UL> <LI>Returns expression1 if expression1 is not NULL.</LI><LI>Returns expression2 if expression1 is NULL.</LI><LI>Returns NULL if both input expressions are NULL.</LI></UL><P>regards,</P><P>Filipe</P> Mon, 22 May 2017 18:39:30 GMT https://community.sap.com/t5/technology-q-a/hana-ifnull-function-doubt/qaq-p/456002 former_member280546 2017-05-22T18:39:30Z https://community.sap.com/t5/technology-q-a/hana-ifnull-function-doubt/qaa-p/456003#M70907 <P>Once the column STD1 is flagged as "NOTNULL" the actual value in it is empty not null. That's the reason why the function is not working in this case.</P> Thu, 25 May 2017 18:40:26 GMT https://community.sap.com/t5/technology-q-a/hana-ifnull-function-doubt/qaa-p/456003#M70907 former_member280546 2017-05-25T18:40:26Z