Null value remove

[risabhroy_03]

I have a dimension named "T$BOLA" and I want to remove both NULL and blank values from it in the table.

I am using the below script 

where (("T$BOLA") <> '-') and (trim("T$BOLA") <> '');

but still I can see few cases where it is coming.

Please help.

[stevejoyce]

where (("T$BOLA") <> '-') and (len(trim("T$BOLA") )>0);

should catch empty and nulls

[risabhroy_03]

Still one  '-' is coming

[stevejoyce]

maybe trim the - also.

where ((trim("T$BOLA") <> '-') and (len(trim("T$BOLA") )>0);

[risabhroy_03]

Still one -  is coming

[stevejoyce]

sounds odd.  on the front-end do some string /null calcuations on it and see if you can figure out what it's being recognized as.

add a table with [T$BOLA] and select that record.  do a len([T$BOLA]),  [T$BOLA] ='-', isnull([T$BOLA]) see if you can figure out what it is.  or maybe if you can share sample input data.

[risabhroy_03]

Tried everything