nice and easy ..
thanks for the question ..
Also, about the explanation
The row with Comment 'row 3' is rejected by database engine because decimal integer 2 (which is binary 10) results in an attempt to insert 1 (0 was truncated because it is the least significant digit)
I don't think, it works like that ; BIT datatype stores only 1,0 or NULL ; (True/False goes as 1 /0). even inserting 7777777 or -1 gets inserted as 1 .
Apart from that ,unrelated to the question, as per my view indexing a bit column is really not necessary, as the range of value is limited ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: