Itzik Ben-Gan covers some underutilized functions and function overloads in T-SQL:
TRIM is more than LTRIM(RTRIM())
SQL Server 2017 introduced support for the function TRIM. Many people, myself included, initially just assume that it’s no more than a simple shortcut to LTRIM(RTRIM(input)). However, if you check the documentation, you realize that it’s actually more powerful than that.
This article is an excellent argument in favor of reading the documentation, as all of it is in there but it’s easy to miss.