```
WHERE CASE WHEN cksp.status IS NOT NULL THEN ckspc.is_include_in_pipeline = 1 
      ELSE 1=1 
      END

```

Here i want like if cksp.status is not null then condition should be cksp.is\_include\_in\_pipeline = 1 ELSE ignore the where condition