3 Changing case and trimming spaces in SQL Server: LOWER, UPPER, LTRIM, RTRIM and TRIM functions

In this video, we will be looking at how to change case of strings, and how to remove leading and trailing spaces.
My SQL Server Udemy courses are:
----
My Excel for PC courses are:
----
in this video, WE'LL HAVE A LOOK at hOw you CaN change the case of strings using the LOWER and UPPER functions.
We'LL ALSO look at how we can get rid of leading and trailing spaces, using LTRIM and RTRIM. However, we'll also see what else TRIM, a new function (from SQL Server 2016), can do.