microsoft.public.sqlserver.server - Changing Bit display from true to 1

Author

Changing Bit display from true to 1

gary

2002-11-11, 9:23 am

I have written some code that is being displayed on the asp page as true or
false and it would help if I could display it as 1 or 0

Thanks inadvance
Gary

Ricky Artigas

2002-11-11, 10:24 am

SELECT CASE WHEN col_name = 1 then '1', when col_Name = 0 then '0' end as
col_description
FROM your_table.

;o)

"gary" <gary@extremecolor.com> wrote in message
news:uxmpcEZiCHA.2456@tkmsftngp12...
> I have written some code that is being displayed on the asp page as true
or
> false and it would help if I could display it as 1 or 0
>
> Thanks inadvance
> Gary
>
>

Sponsored Links