Hello,

if I select a value:

…a.standort,

  case when(a.fertigstellung <= :fstichtag) then 4 when ((fertigstellung >= :fstichtag or fertigstellung is null) and abnahme <= :fstichtag) then 3 end

  from …

and I would check this in the where-condition, should I write the entire text again or can I do it shorter?

Example:

Where case… is not null

If I set the Field „as fielda“, I cannot do this: „where fielda is not null“

Thanks a lot!

Best regards

Olaf