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?

Answer 1

declare @b bit = 1

select convert (int, @b)

or

select cast(@b as int)

more

Answer 2

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;

Answer 3

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.