Chapter 11. Restructuring the Appearance of Data
During this hour, you learn how to restructure the appearance of output results using a wide array of functions, some ANSI standard functions, and other functions based on the standard and several variations used by some major SQL implementations.
This hour’s highlights include:
Introduction to character functions
How and when to use character functions
Examples of ANSI SQL functions
Examples of common implementation-specific functions
Overview of conversion functions
How and when to use conversion functions
ANSI Character Functions
Character functions are functions used to represent strings in SQL in formats alternate to how they are stored in the table. The first part of this hour discusses the concepts ...