Hi,

I have a requirement where i need to use LIKE operator in where clause.
I figured out how to use it.

  
--other where clause--
AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%&ADDRESS|%'

The address parameter is not a mandatory input and if the user is not filtering for Address it will pass _FOC_NULL and in that case
my whole report given empty data because the where clause filter for

  
--other where clause--
AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%_FOC_NULL%'

I think it should be
AND DIM_LOCATION.ADDRESS_LINE_1 LIKE '%_FOC_NULL%',but when the user filters for some address then it should be AND.

Any logical workaround to tackle this situation?

This message has been edited. Last edited by: srajeevan,

Can you use a second WHERE ADDRESSLINE LIKE instead of using AND? That way what happens to the second where test doesn't effect the first one.

  
WHERE first condition;
-IF &ADDRESS EQ _FOC_NULL GOTO SKIP;
WHERE second condition;
-SKIP

Thanks BabakNYC it worked.