Converting Boolean to Integer SQl Server

Question

I am trying to convert a boolean to an integer. Here is the coding I have so far:

Click to copy

CONVERT(int, column_name) AS ALIAS

The query runs without an error. However, it is not producing the results I want.

What do I need to do?

Answer 1

What you are doing should be enough to convert BIT values to int as shown below.

Click to copy

DECLARE @TABLE TABLE(Value BIT)

INSERT INTO @TABLE VALUES 
(1),(0),(1),(0),(1),(0),(1)

Query

Click to copy

SELECT  Value
       ,CAST(Value AS INT)  AS Casted
       ,CONVERT(int, Value) AS Converted
FROM @TABLE 

Result Set

Click to copy

╔═══════╦════════╦═══════════╗
║ Value ║ Casted ║ Converted ║
╠═══════╬════════╬═══════════╣
║     1 ║      1 ║         1 ║
║     0 ║      0 ║         0 ║
║     1 ║      1 ║         1 ║
║     0 ║      0 ║         0 ║
║     1 ║      1 ║         1 ║
║     0 ║      0 ║         0 ║
║     1 ║      1 ║         1 ║
╚═══════╩════════╩═══════════╝