Converting image columns to binary types  Converting NULL value

Chapter 2: Transact-SQL Functions

Converting other types to bit

Exact and approximate numeric types can be converted to the bit type implicitly. Character types require an explicit convert function.

The expression being converted must consist only of digits, a decimal point, a currency symbol, and a plus or minus sign. The presence of other characters generates syntax errors.

The bit equivalent of 0 is 0. The bit equivalent of any other number is 1.





Copyright © 2005. Sybase Inc. All rights reserved. Converting NULL value

View this book as PDF