john.arnott (4/5/2010)

---

malleswarareddy_m (4/4/2010)

---

Good QOD.This Question gives good information about bit datatypes.

when we use space or all zero it bit will convert it into zero.If we give numeric(numbers) it will convert it into one.

. . . .

This is true for other numeric datatypes as well. Spaces or empty strings are implicitly converted to zero

DECLARE @MyNum int

SET @MyNum = ' '

-- attempt arithmetic operation

Select @myNum * 4

-- result is 0, not an error.