Return Bit Value as 1 0 and NOT True False in SQL Server

Question

I have a Table in SQL Server 2000 with BitValue Column  But  it is being displayed as True False in SQL Server Management Studio  When I do a Select   from Tablename it returns the BitValue Column values as True False  How do I force it to return the value as bits  1 0  instead of True False  Any Help will be really appreciated

User · Answer

Try this - SELECT Case WHEN COLUMNNAME 0 THEN  sex                ELSE WHEN COLUMNNAME 1 THEN  Female  END AS YOURGRIDCOLUMNNAME FROM YOURTABLENAME   in your query for only true or false column

User · Answer

This can be changed to 0 1 through using CASE WHEN like this example   SELECT   CASE WHEN SchemaName TableName BitFieldName    true  THEN 1 ELSE 0 END AS  bit Value    FROM SchemaName TableName

User · Answer

Try with this script  maybe will be useful   SELECT CAST  TRUE  as bit  -- RETURN 1 SELECT CAST  FALSE  as bit  --RETURN 0   Anyway I always would use a value of 1 or 0  not TRUE or FALSE   Following your example  the update script would be   Update Table Set BitField CAST  TRUE  as bit  Where ID 1

User · Answer

Modify your query to generate the output that you want   Try casting them to int   select cast bitFlag as int    Or  if you like  use case   select  case when bitFlag   0 then 0 else 1 end

User · Answer

just you pass this things in your select query  using CASE  CASE WHEN  gender 0 then  Female  WHEN  gender 1 then  Male  END as Genderdisp

[sql] Return Bit Value as 1/0 and NOT True/False in SQL Server

Examples related to sql

Examples related to select

Examples related to bit