How HANA handle NULL values

[Former Member]

Hi frzz,

Can any one explain me how exactly HANA handles NULL values??

Best Regards,

Krishna.

[rindia · Accepted solution]

Krishna,

Your question is too generic. Can you let us know your scenario?

Regards

Raj

[Former Member · Accepted solution]

Hi Raj,

In my scenario, if the managerID field is like '0000000' or 'null' i need to convert it as 'blank space'

for value '0000000' i can do trim(), but to handle null values how can i convert the null value to blank space??

Best Regards,

Krishna.

[rindia · Accepted solution]

You can use isnull().

For example: if(isnull("column1"),'',"column1")

Regards

Raj

[Former Member · Accepted solution]

I have written the code as

if( ((("ManagerID" = '00000000')) OR  (isnull("ManagerID") )), trim("ManagerID"), "ManagerID")

But if the managerID is 'null' am not getting the blank spaces. How to handle null values in such case???

[Former Member · Accepted solution]

Yes Raj..... you are right....its my mistake...we can directly replace the value with ' ' instead of doing trim().

Thanks a lot.

Best Regards,

Krishna.

[Former Member · Accepted solution]

Hi Krishna,

You can use IFNULL for the SQL queries/script instead of ISNULL . Since ISNULL is binary function and will be mostly used for the CE Functions based Calc views.

Try using the same queries with IFNULL instead of ISNULL, it should work

Best Regards

Rahul Jha