• This works with TRUE or FALSE >

    DECLARE @mybit bit;

    SET @mybit = 'true';

    SELECT @mybit

    Though yes/no , on/off do not. Just want to add to this post.

    ----------------------------------------------------