When saving a boolean value to a Microsoft® SQL Server 2000 database. In SQL Server 2000, boolean values are represented as data type "bit", with valid values of numeric 0 or 1. When building a SQL INSERT or UPDATE statement, we need to convert a value of TRUE or FALSE easily to a 1 or 0 respectively.
I have found the easiest way is to use the IIF command. Depending on your coding preferences, you should find one of the two choices below will work well for you:
Dim MySQLBoolean as string = IIF(MyBoolean, "1", "0")
Dim MySQLBoolean as integer = IIF(MyBoolean, 1, 0)
Compared to an IF-THEN-ELSE approach, I like the IIF approach since it delivers the desired result in a single line of code.Readabilityy in code is very important, but with all other things being equal, one line of code is generally more readable than five lines of code.