Hello,

I am copying a table from one sql server to another and
some of the columns are coming over as blank strings, I
want these converted to NULLS, but at the moment they come
over as blank strings, is there an easier way other than
doing a column by column activex transform to convert
these to nulls?

Thanks

Julian

Have a look at the NULLIF() function



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Julian" <JulianPotter (AT) Hotmail (DOT) com> wrote