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 ...

Get Sams Teach Yourself SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.