Excluding NULL values in where class

[sridhar_sigired]

Hello,

I have a QVD and in one of the field called "Store" null values are there. I need to exclude those NULL records.

I have tried with below conditions but i cannot able to filter those values. Can anyone help me on this?

Where Store<>' ';

Where Store <> 'NULL ';

[tresesco]

Try like:

Where Len(Trim(Store))>0;

[Anil_Babu_Samineni]

You can try this too

Where Store;

[miguelbraga · Accepted solution]

Have you tried?

Where Store <> null();

Best regards,

D.A. MB

[pradeep_s]

Use not IsNull(Store)

or

Store <> Null()

[sridhar_sigired]

Thank you all for quick response.

[Anil_Babu_Samineni]

Srishar, Does Tresesco suggestion is working or not?

[sridhar_sigired]

His responses always works so i kept his response as helpful and used migual response.