November 2008
Intermediate to advanced
591 pages
17h 28m
English
ANSI SQL provides a function named CASE that can be used to create IF/THEN flow-control logic within queries or UPDATE statements. The CAST function is for converting between datatypes and is also in the ANSI standard. All of the databases covered in this book provide ANSI standard support for both the CASE and CAST functions.