>Hello All:
>
>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?
>
>Thanks in advance for any suggestions:
Something like
update yourtable set whatever='' where whatever is null
Unfortunately, you need to supply default values in script (AFAIK - if there's a trick, I'd like to know). There is no BLANK command.