O'Reilly logo
  • Dustin Waybright thinks this is interesting:

UPPER, LOWER, LTRIM, RTRIM, and FORMAT functions.

The first four functions are self-explanatory (uppercase form of the input, lowercase form of the input, input after removal of leading spaces, and input after removal of trailing spaces)

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

LTRIM and RTRIM, remove spaces.