I want to insert a default value in a date field, if the
value in the input text file is blank.

I tried, <null>, null, 1 space, 00/00/00, 99/99/99, and
none of them work (gets cast or datatype error). 1/1/1900
works but I wanted to insert a blank value.

Please Help!!

what about

ISNULL(NULLIF(colName,""),'19990101')



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"desperate" <anonymous (AT) discussions (DOT) microsoft.com> wrote