Single row funtions
Functions make the basic query block more powerful and are used to
manipulate data values. This is the first of two lessons that explore functions.
You will focus on single row character, number, and date functions, as well as
those functions that convert data from one type to another, for example,
character data to numeric.
At the end of this lesson, you should be able to
Explain the various types of functions available in SQL.
Identify the basic concepts of using functions.
Use a variety of character, number, and date functions in SELECT statements.
Explain the conversion functions and how they might be used....