For more information, see:
- For examples that show how the length of the character type in the first SELECT statement affects the result set, see Attributes of a Set Result.
- For examples that show how the numeric data type in the first SELECT statement affects the result set, see Example: Effect of the Order of SELECT Statements on Data Type.
- The character set of the expression in the first SELECT statement determines the character set for the entire query. For more information, see Example of How the Character Set is Determined for the Query.