>SQL Server treats NULL Date as 01/01/1900. It's a default behaviour.
>
>Bye
>Jayesh
>
>>When I have a view which reads a date field with no value in it, the view uses a default date with 1899 or something like that. Is this considered standard behaviour? Is there an easy way to sidestep this?
>>
>>Thanks,
>>
>>Peter

Thanks to all of you! Problem solved!