Louis Davidson plays around with the new string concatenation operator:
I was looking around for stuff to post about the other day, so I read through the latest What’s new in SQL Server 2025 and I found this:
|| (String concatenation) Concatenate expressions with expression
||expression.My interest was piqued to say the least. Using + to concatenate string data has always had its issues, and as much as I love the
CONCATfunction, it is kind of clunky to use versus a proper operator.
This is part of the ANSI SQL standard, and that standard does specify most of its behavioral patterns. Read on as Louis tries it out in a variety of circumstances.