Home Forums Article Discussions Article Discussions by Author Discuss content posted by pramod singla SQL Server 2012 Concat RE: SQL Server 2012 Concat
Hugo Kornelis
SSC Guru
Points: 64780
More actions
July 9, 2013 at 3:13 am
#1630692
Carlo Romagnano (7/9/2013)select concat(null + 'Hello','testString') as a , null+'testString' as bIt simply returns 'testString', NULL😀
Carlo Romagnano (7/9/2013)
select concat(null + 'Hello','testString') as a , null+'testString' as b
, null+'testString' as b
It simply returns 'testString', NULL
😀
Yup. If you wanted to get 'HellotestString', you'd use SELECT CONCAT(NULL, 'Hello', 'testString');