Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS Expression RE: SSIS Expression
Koen Verbeeck
SSC Guru
Points: 259085
More actions
March 18, 2015 at 1:55 am
#1784666
If you have SQL 2012 or up:
REPLACENULL(address1,address2)
If not:
(ISNULL(address1)) ? address2 : address1
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP