The SUBSTRING() function has been one of my most often used tools over the years, often to massage data or help display a partial string. While it’s been a very useful function, there has been an annoying limitation for me in the past that is removed in SQL Server 2025. This short article looks at the change.
With a new version of SQL Server coming, I wanted to cover some of the T-SQL code changes. This is part of a series on how the T-SQL language is evolving in this version.
Note: some of these changes are already available in