Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gerald Britton Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and RE: Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

  • June 5, 2014 at 1:08 am

    #1719099

    Thanks!

    declare @t varchar(10) = 'FALSE'

    ,@b bit

    SET @b-2 = CAST(@t as bit)

    select @b-2

    WHERE @b-2 = 'FALSE'