CHAPTER 5 Moving Data In and Out of Databases
207
The second table shows implicit (I), explicit (E), and unsupported (U)
conversions when the
WHERE clause in a SELECT statement is based on an
arithmetic operation (+, –, etc.).
Figure 5-3: IQ conversions for arithmetic operations
Note In arithmetic operations, bit data is implicitly converted to tinyint.