Return int value from boolean field in SQL select Is there a way to return an int value for a boolean field in a sql select statement?
declare @b bit = 1

select convert (int, @b)


or

select cast(@b as int)


more