I am moving data from one table to another and I want a date field to change from null to a default value. What is the best way to do this in SQL Server(2000) ? 

I want something similar to the IIf function in Access. 
Like IIF(DateBegin is null, #1/1/2000#,DateBegin)