Return int value from boolean field in SQL select

Question

Is there a way to return an int value for a boolean field in a sql select statement?

Do you mean a "bit" field? SQL Server has no boolean. And can you give some more background please so we understand the context. — gbn, Sep 21 '11 at 15:23

score 6 · Answer 1 · answered Sep 21 '11 at 15:21

6

declare @b bit = 1

select convert (int, @b)

or

select cast(@b as int)

answered Sep 21 '11 at 15:21

garik

score 2 · Answer 2 · 2011-09-22T10:49:43.160

2

If that is really a boolean column, you can do this:

SELECT case 
          when boolean_value then 1
          else 0 
       end as boolean_as_integer
FROM your_table

that way you can also return other values than 1/0 if you need to.

edited Sep 22 '11 at 10:49

answered Sep 22 '11 at 10:44

score 1 · Answer 3 · answered Aug 17 '20 at 15:05

1

In SQL Server, you can use CAST()

SELECT CAST(Bit_Column TO INT)

but it won't work in MySQL. For MySQL, you can use

SELECT IF(Bit_Column, 1, 0)

answered Aug 17 '20 at 15:05

Paresh_Wadhwani

score 1 · Answer 4 · answered Sep 22 '11 at 09:14

1

I think this is not SQL Server. Maybe PostgreSQL? Try this

create table booln1(a  boolean);
insert into booln1 values(true),(false);
select a, cast(a as int) as a1 from booln1;

answered Sep 22 '11 at 09:14

msi77

4 Answers4