>>By empty you meant NULL, right?
>>
>>order by coalesce(myDate, '30000101') DESC
>
>An empty date value is stored on the field when there is no value.
SQL Server doesn't have that for dates. It is either NULL or some default value.
If it's not broken, fix it until it is.
My Blog 
