CREATE FUNCTION [dbo].[BitToChar_ufn] ( -- Add the parameters for the function here
                                  @b1 BIT
                                , @b2 BIT
                                , @b3 BIT
                                , @b4 BIT
                                , @b5 BIT
                                , @b6 BIT
                                , @b7 BIT
                                , @b8 BIT
                                , @b9 BIT
                                , @b10 BIT
                                , @b11 BIT
                                , @b12 BIT
                                , @b13 BIT
                                , @b14 BIT
                                , @b15 BIT
                                , @b16 BIT
                                , @b17 BIT
                                , @b18 BIT
                                , @b19 BIT
                                , @b20 BIT
                                , @b21 BIT
                                , @b22 BIT
                                , @b23 BIT
                                , @b24 BIT
                                , @b25 BIT
                                , @b26 BIT
                                , @b27 BIT
                                , @b28 BIT
                                , @b29 BIT
                                , @b30 BIT
                                , @b31 BIT
                                , @b32 BIT
                                , @b33 BIT
                                , @b34 BIT
                                , @b35 BIT
                                , @b36 BIT
                                , @b37 BIT
                                , @b38 BIT
                                , @b39 BIT
                                , @b40 BIT
                              )
RETURNS char(40)
AS BEGIN
    -- Declare the return variable here
    DECLARE @Result char(40)

    -- Add the T-SQL statements to compute the return value here
    -- SELECT @Result = @b1
    DECLARE @s1 CHAR(1),
        @s2 CHAR(1),
        @s3 CHAR(1),
        @s4 CHAR(1),
        @s5 CHAR(1),
        @s6 CHAR(1),
        @s7 CHAR(1),
        @s8 CHAR(1),
        @s9 CHAR(1),
        @s10 CHAR(1),
        @s11 CHAR(1),
        @s12 CHAR(1),
        @s13 CHAR(1),
        @s14 CHAR(1),
        @s15 CHAR(1),
        @s16 CHAR(1),
        @s17 CHAR(1),
        @s18 CHAR(1),
        @s19 CHAR(1),
        @s20 CHAR(1),    
        @s21 CHAR(1),
        @s22 CHAR(1),
        @s23 CHAR(1),
        @s24 CHAR(1),
        @s25 CHAR(1),
        @s26 CHAR(1),
        @s27 CHAR(1),
        @s28 CHAR(1),
        @s29 CHAR(1),
        @s30 CHAR(1),    
        @s31 CHAR(1),
        @s32 CHAR(1),
        @s33 CHAR(1),
        @s34 CHAR(1),
        @s35 CHAR(1),
        @s36 CHAR(1),
        @s37 CHAR(1),
        @s38 CHAR(1),
        @s39 CHAR(1),
        @s40 CHAR(1)

    SET @s1 = CASE @b1
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s2 = CASE @b2
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s3 = CASE @b3
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s4 = CASE @b4
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s5 = CASE @b5
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s6 = CASE @b6
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s7 = CASE @b7
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s8 = CASE @b8
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s9 = CASE @b9
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s10 = CASE @b10
                 WHEN 1 THEN 'Y'
                 WHEN 0 THEN 'N'
                 ELSE ' '
               END    

    SET @s11 = CASE @b11
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s12 = CASE @b12
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s13 = CASE @b13
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s14 = CASE @b14
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s15 = CASE @b15
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s16 = CASE @b16
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s17 = CASE @b17
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s18 = CASE @b18
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s19 = CASE @b19
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s20 = CASE @b20
                 WHEN 1 THEN 'Y'
                 WHEN 0 THEN 'N'
                 ELSE ' '
               END    

    SET @s21 = CASE @b21
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s22 = CASE @b22
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s23 = CASE @b23
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s24 = CASE @b24
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s25 = CASE @b25
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s26 = CASE @b26
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s27 = CASE @b27
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s28 = CASE @b28
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s29 = CASE @b29
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s30 = CASE @b30
                 WHEN 1 THEN 'Y'
                 WHEN 0 THEN 'N'
                 ELSE ' '
               END    

    SET @s31 = CASE @b31
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s32 = CASE @b32
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s33 = CASE @b33
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s34 = CASE @b34
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s35 = CASE @b35
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s36 = CASE @b36
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s37 = CASE @b37
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s38 = CASE @b38
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s39 = CASE @b39
                WHEN 1 THEN 'Y'
                WHEN 0 THEN 'N'
                ELSE ' '
              END    
    SET @s40 = CASE @b40
                 WHEN 1 THEN 'Y'
                 WHEN 0 THEN 'N'
                 ELSE ' '
               END    


    SET @Result = @s1 + @s2 + @s3 + @s4 + @s5 + @s6 + @s7 + @s8 + @s9 + @s10
                + @s11 + @s12 + @s13 + @s14 + @s15 + @s16 + @s17 + @s18 + @s19 + @s20
                + @s21 + @s22 + @s23 + @s24 + @s25 + @s26 + @s27 + @s28 + @s29 + @s30
                + @s31 + @s32 + @s33 + @s34 + @s35 + @s36 + @s37 + @s38 + @s39 + @s40
    -- SELECT @Result
    -- Return the result of the function
    RETURN @Result

   END
GO