In this lesson, you’ll learn what functions are, what types of functions T-SQL supports, and how to use these functions.
Like almost any other computer language, SQL supports the use of functions to manipulate data. Functions are operations that are usually performed on data, usually to facilitate conversion and manipulation.
An example of a function is
RTrim(), which we used in the last lesson to trim any spaces from the end of a string.