Sorting Strings in SQL Server 2019: A Step-by-Step Guide

Why does my SQL scalar function sometimes throws "Subquery returned more than 1 value. This is not permitted..."?