Subject long condition faster?
Author Check_Mail



if I select a value:



  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?




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