IS NOT NULL not functioning as expected

[#1]

Hello,

When trying to apply 'IS NOT NULL' operator as filter(where to_date(column) Is Not Null) on the DB column  it is not working as expected and pulling the null values into the result.

We are using HANA Revision 33.Below is the SQL generated from BO tool we are using BO 4.0.

Let me know if you have ever faced this issue.

thanks!

[henrique_pinto]

If you just want to see if the value is null, you don't need to apply the to_date() conversion beforehand. Just do WHERE "COLUMN" IS NOT NULL.

[Former Member]

Hi,

You can use below statement for filtering Null Values in HANA DB

Column_Name<>''(Make sure no space betwen '')

[lbreddemann]

Two mistakes here:

1. don't digg out two year old threads, that nobody is interested in anymore. Just don't.

2. the unequal condition you posted tests for an empty string, not for NULL and that's two separate things in SAP HANA.

- Lars