Boolean question

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 Flase - 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!!!

Do you currently have records in that table for dbo.BookAll.AdhereBarCodeCvr that would be considered a NULL value (not true of false)?

S-

No, all of the data in the field is either True or False.

I can't see anything that is wrong with your statement.

What kind of error message are you getting? If you limit your statement to one record does it error out?

S-

The field is staying with the Boolean and not changing to the "B" which is to denote "Barcode".

Appreciate your help.