I am trying to convert a boolean to an integer. Here is the coding I have so far:
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?
-
I should note that it does convert the values to integers. However, it only returns 0s. Why is this happening?user3109653– user31096532014-06-10 21:28:46 +00:00Commented Jun 10, 2014 at 21:28
-
Why do you need a boolean to be an integer? they're already effectually only 1 or 0. Why not just check for true or false?Jhecht– Jhecht2014-06-10 21:34:14 +00:00Commented Jun 10, 2014 at 21:34
-
Maybe all the records have false in that field. What is the rdbms? That's relevant.Dan Bracuk– Dan Bracuk2014-06-10 21:34:16 +00:00Commented Jun 10, 2014 at 21:34
-
you mean you converting BIT to integer? Can u show sample data from "column_name" ?Comfortably Numb– Comfortably Numb2014-06-10 21:40:25 +00:00Commented Jun 10, 2014 at 21:40
-
I need to convert it to an int because I want to aggregate it. I'm using SQL Server 2012user3109653– user31096532014-06-10 21:40:37 +00:00Commented Jun 10, 2014 at 21:40
Add a comment
|
1 Answer
What you are doing should be enough to convert BIT values to int as shown below.
DECLARE @TABLE TABLE(Value BIT)
INSERT INTO @TABLE VALUES
(1),(0),(1),(0),(1),(0),(1)
Query
SELECT Value
,CAST(Value AS INT) AS Casted
,CONVERT(int, Value) AS Converted
FROM @TABLE
Result Set
╔═══════╦════════╦═══════════╗
║ Value ║ Casted ║ Converted ║
╠═══════╬════════╬═══════════╣
║ 1 ║ 1 ║ 1 ║
║ 0 ║ 0 ║ 0 ║
║ 1 ║ 1 ║ 1 ║
║ 0 ║ 0 ║ 0 ║
║ 1 ║ 1 ║ 1 ║
║ 0 ║ 0 ║ 0 ║
║ 1 ║ 1 ║ 1 ║
╚═══════╩════════╩═══════════╝
