[firebird-support] long condition faster?

['Check_Mail' check_m...@satron.de [firebird-support]]

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