Introduction.

Chapter 1: Exploring Popular SQL Implementations.

Chapter 2: Functions: Concept and Architecture.

Chapter 3: Comparison of Built-in SQL Functions by Vendor.

Chapter 4: SQL Procedural Extensions and User-Defined Functions.

Chapter 5: Common ANSI SQL Functions.

Chapter 6: Oracle SQL Functions.

Chapter 7: IBM DB2 Universal Database (UDB) SQL Functions.

Chapter 8: Microsoft SQL Server Functions.

Chapter 9: Sybase ASE SQL Built-In Functions.

Chapter 10: MySQL Functions.

Chapter 11: PostgreSQL Functions.

Chapter 12: ANSI SQL User-Defined Functions.

Chapter 13: Creating User-Defined Functions in Oracle.

Chapter 14: Creating User-Defined Functions with IBM DB2 UDB.

Chapter 15: Creating User-Defined Functions Using Microsoft SQL Server.

Chapter 16: Creating User-Defined Functions in Sybase SQL.

Chapter 17: Creating User-Defined Functions in MySQL.

Chapter 18: Creating User-Defined Functions in PostgreSQL.

Chapter 19: Reporting and Ad Hoc Queries.

Chapter 20: Using Functions for Migrating Data.

Chapter 21: Using Functions to Feed a Data Warehouse.

Chapter 22: Embedded Functions and Advanced Uses.

Chapter 23: Generating SQL with SQL and SQL Functions.

Chapter 24: SQL Functions in an Application.

Chapter 25: Empowering the Query with Functions and Views.

Chapter 26: Understanding the Impact of SQL Functions on Query and Database Performance.

Chapter 27: Useful Queries from the System Catalog.

Appendix A: Built-in Function Cross-Reference Table.

Appendix B: ANSI and Vendor Keywords.

Appendix C: ANSI and Vendor Data Types.

Appendix D: Database Permissions by Vendor.

Appendix E: ODBC and Stored Procedures and Functions.

Appendix F: JDBC and Stored Procedures/Functions.

Glossary.

Index.