Koen Verbeeck takes a peek at a pair of new features in SQL Server 2025:
Often new T-SQL functionality is released first in the Azure cloud environment, before it makes its way to the on-premises SQL Server product. Recently, a new T-SQL function and operator went general available in Azure SQL DB (and Azure SQL Managed Instance): UNISTR and the ANSI SQL string concat operator (||). In this tip, we’ll introduce you to both concepts.
Koen looks at these in Azure SQL Database, though if you have the public preview of SQL Server 2025, you can try both out there as well.