Case Statement on a bit datatype

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Case Statement on a bit datatype

Author

Topic

hrishy
Starting Member

47 Posts

Posted - 2008-05-04 : 07:41:13

Hi

I have a column of datatype bit.When i run a case statement i get a error.


SELECT Name,Married =
CASE Married
	WHEN Married = '1'THEN  'Y' 
	WHEN Married = '0'  THEN 'N'
        ELSE NULL
	END,
LastName
from  Person

The above code gives a error message
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.

regards
Hrishy

ayamas
Aged Yak Warrior

552 Posts

Posted - 2008-05-04 : 09:26:57

Try this

SELECT Name,Married =
CASE Married
WHEN 1 THEN 'Y'
WHEN 0 THEN 'N'
ELSE NULL
END,
LastName
from Person

NeilG
Aged Yak Warrior

530 Posts

Posted - 2008-05-04 : 09:37:11

There is no need for the married in the when area

SELECT Name,
Married =
CASE Married
WHEN 1 THEN 'Y'
WHEN 0 THEN 'N'
ELSE NULL
END,
LastName
from Person

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-04 : 09:52:32

quote:
Originally posted by hrishy

Hi

I have a column of datatype bit.When i run a case statement i get a error.

SELECT Name,Married =
CASE Married
WHEN Married = '1'THEN 'Y'
WHEN Married = '0' THEN 'N'
ELSE NULL
END,
LastName
from Person

The above code gives a error message
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '='.

regards
Hrishy