Filtering Database Rows Without Using SUBSTRING Function

Categorizing Result Sets with RowNumber: A Deep Dive into SQL Server Techniques and Alternatives

Calculating the Median of Aggregated Rows with SQL: A Practical Guide for Data Analysis

Finding Equal Row Sets Across Different Tables in SQL Server Using the FOR XML Trick or Alternative Approaches