buntyteg (8/14/2012)
in correct answer -1,1 is correctbut how 25 is correct
means to say... in bit datatype how we can store 25 (2 digit) value
??????
If it helps, think of it this way:
DECLARE @BitValue BIT;
SET @BitValue = CASE WHEN ValueToConvert = 0 THEN 0 ELSE 1 END;
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes