Converting Unicode to German Umlauts with SQL Queries

Understanding SQL Server's Substring Function Behavior with Non-Latin Characters: Prefixing with 'N' and Unicode Considerations