Boolean question

[Gary Nelson]

In Access2000 frontend, SQL Server (backend), I have a stored procedure that
I am attempting to add a field to. Here's the scoop.

I have a report that I have been asked to show a "B" for any items that
require a barcode. The data that is currently in the field is True or
False - a Boolean. Rather than showing a True or False, I want to show just
the letter "B". Please see the code below that I have written.

'BarCode'=
CASE
WHEN dbo.BookAll.AdhereBarCodeCvr= 1Then 'B'
END,

'Drilling'=
CASE
WHEN dbo.BookAll.HoleDrilling = 1Then 'D'
END,

'Shrinkwraps'=
CASE
WHEN dbo.BookAll.Shrinkwrap = 1Then 'S'
END,

Now, my dilemma is that the Drilling and Shrinkwrap code work, but the
barcode does not. ANy ideas what I am doing wrong and how to correct it?

Thanks for your help, and Merry Christmas!!!