+1 Thank you for this easy one. I've been educating people about the news in SQL server 2012 and I really like this function. Not becase the possibility to concat null values, but to be able to concatenate strings with numeric values. Of course, concatenating strings are often used for presentation and that should be handled in the presentation layer and not in the database.