how to select a empty string or white space in HANA SPS 10

[former_member197081]

I tried using where "colName" = '', It's not working. And also please suggest how to select all the Empty or Null columns (no value through out the table). My target is list all the Null or empty columns in any table.

[SergioG_TX]

for empty records:

select *

from <SCHEMA.TABLE>

where ltrim(rtrim("YOUR_COLUMN")) = '';

for null records:

select *

from <SCHEMA.TABLE>

where "YOUR_COLUMN" is null;