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