IS NOT NULL not functioning as expected

[Former Member]

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_member187153]

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

[Former Member]

Hi Ravi,

I tried the same filter in SQL editor its working fine and also not pulling the null values. I am on HANA DB Revision 28.

Can you mention datatype and values of the column you are using in to_date function.

-Ruchi

[Former Member]

Hello Ruchi-

Thanks for your response.

The data type of the field we are using in the condition is DATA TIME STAMP field, we are getting rid of time stamp using the to_date function. to display in YYYY-MM-DD

Thanks!