Does anyone know if MS SQL contains default dates that indicate an invalid date or
a default expiry date? For example I believe that DB2 uses the year 9999 as an invalid date
or one to be avoided.

Along the same lines how would one convert a MS SQL datetime stamp into a Julian date
format? I can`t find any SQL to accomodate this function at all.

Any help would be appreciated.

Garth Martin