Observe that the type of the COALESCE expression is determined by the returned element, whereas the type of the ISNULL expression is determined by the first input.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
ISNULL forces the data type of the first input, so a VARCHAR(3) data type then converts the second input from VARCHAR(10) to VARCHAR(3).
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56874/