Character functions returning character values

- [Narrator] Database single-row built-in functions can be divided into several categories; character, number, date, conversion, and the catch all general. I'll give a detailed overview of the first subset of character single-row functions in this video, the ones that specifically return character strings, and how they are used in the SELECT statement, or any SQL statement. To see how a character functions fit in with the rest, here's an overview of single-row functions. They fall into five basic categories; character, numeric, date, and date arithmetic, conversion, and general. Some of the conversion functions and general functions may technically fall into the number functions, only because they return a number, but we'll cover them in a different lesson. The Character functions can be broken down into two general subcategories; those character functions that manipulate character strings and return a modified or partial string such as sub-string. And the other category does some…