Hi @All, I am comparing two columns in saved search like CASE WHEN {parentcustomer.x} != {y} THEN 1 ELSE 0 END and if its 1 i should get a row. But when there is an empty value in x and value present in Y, I am not getting rows. Any idea how to handle empty values? Thanks in advance.

@vilaspadole maybe you could try adding one more condition

I put concatenate on both values and it worked

For future reference use

IS NULL

or NVL() to handle a null value and assign it a value