Character functions returning numeric values

- [Instructor] Database single-row built-in functions can be divided into several categories, character, number, date, conversion, and a catch-all general. I'll give a detailed overview of the second subset of character single-row functions in this video, the ones that specifically return numeric values, and how they are used in a SELECT statement, or any SQL statement for that matter. To see how 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 that 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…