In this series on common SQL Server problems, I provide some guidance around the error message "An invalid length was passed to the LEFT or SUBSTRING function…" errors.

I detail issues we experienced (and maybe should have expected) while upgrading to SQL Server 2025.