Can't. SQL Server doesn't support anything like VFP's blank date/time. Is there a reason why you can use NULL?
-Mike
>I am trying to set default values to blank dates in SQL Server.
>
>In VFP you can set a new date to {}. But in SQL Server, how do you do it? When I set a datetime field to (' '), I get 01/01/1900.
>
>Thanks.
>
>Bob Bartel