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
- Jayesh