requirement

[Anonymous]

I have two filter some conditions like:

where x='some value' and y='some value' and z=null or z='na'

how to do that ?

[Peter_Cammaert]

IF ((x = 'some value') and (y = 'some value') and (IsNull(z) or (z = 'na')), true-expression, false-expression)

[its_anandrjs]

If you are using this conditions in where condition to filter the data then

Load *

From source

Where

x = 'some value' and y = 'some value' and isnull(z) = -1 or z = 'na';

Or in the conition

If( x = 'some value' and y = 'some value' and isnull(z) = -1 or z = 'na',1 ,0 )