Hello,

Is it possible to optimize this sql clause ?
Thank you in advance.

bernhart

 WHERE  IIF( ?vp_sommeil = .T. , .T. , Employee.lsommeil = ?vp_sommeil )  AND ;
  IIF( EMPTY( ?Vp_debut ) , IIF( EMPTY( ?Vp_nom ) , .T. , TELEPH.Cnomteleph  = ?Vp_nom ) AND  ;
  IIF( ?Vp_lpresent  =  .T. , EMPTY( Employee.Dsortie ) , .T. ) , BETW( Employee.Dentree , ?Vp_debut , ?Vp_Fin )= .T.  OR  ;
  BETW( Employee.Dsortie , ?Vp_debut , ?Vp_Fin )= .T.  OR  ( EMPTY( Employee.Dsortie ) AND Employee.Dentree < ?Vp_debut ) OR ;
  (  Employee.Dsortie > ?Vp_Fin  AND Employee.Dentree < ?Vp_debut ) )    ;
  GROUP BY  Employee.Iid   ORDER BY  Employee.Iid