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