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?
>
--sb--