Rimokas rašė:

>   Bet .... :-((
>
> Su siom where salygom :
>        (JUD1.datephysical>='2011.07.01' or JUD1.datephysical IS NULL)  and
>        (JUD1.datephysical<='2011.07.31' or JUD1.datephysical IS NULL)  and
>        (LIK1.DATEPHYSICAL>= '2011.07.01' or LIK1.datephysical IS NULL) and
>        (LIK1.DATEPHYSICAL<= '2011.07.31' or LIK1.datephysical IS NULL)
> arba
>        isnull( JUD1.DATEPHYSICAL, LIK1.DATEPHYSICAL )>= '2011.07.01' and
>        isnull( JUD1.DATEPHYSICAL, LIK1.DATEPHYSICAL )<= '2011.07.01'
>
>   0 eiluciu ...

Labai tingiu gilintis į tuos daugiaaukščius, tačiau — peno pamąstymams:

SELECT CASE WHET GetDate() = '2011-08-13' THEN 'lygu' else 'nelygu' END

SELECT CASE WHEN DateDiff(day, GetDate(), '2011-08-13') >= 0 THEN 'ši ar 
velesnė' ELSE 'ankstesnė' END


p.s. datas geriau įprasti rašyti ISO standartu, t.y. su brūkšneliais.