Home Forums SQL Server 7,2000 T-SQL Convert Varchar to Bit RE: Convert Varchar to Bit
JeffB
Hall of Fame
Points: 3541
More actions
January 30, 2006 at 4:17 pm
#617848
In SQL, bits are represented by 0 or 1. It doesn't translate the string 'TRUE' to a 1. If the source data is a string 'TRUE', then a case statement has to be used.