You can use IS NULL SQL operator (the same as in VFP) and provide the default date

UPDATE mytable SET DateCol = '<default date>' WHERE DateCol IS NULL

>
>I am trying to programatically detect and change NULL dates in a SQL Server database. Is there a SQL passthrough command that can be issued to detect just NULL dates and replace them with a default date?
>