As mentioned in the previous video, LTRIM removes space from the beginning of a string, and RTRIM removes spaces from the end.

As of SQL Server 2017, there is a new function - TRIM - which does both. However, don't use this on SQL Server 2016 or earlier, as it won't work.