CASE WHEN statement

[strangeBrew12]

Simple question I hope.

I want to do:

CASE WHEN AcctStatus IN ('a','c','o') THEN AcctStatus ELSE NULL END.

Is this the right syntax? Can someone set me on the right path?

Thanks all

JJ

 

[vongrunt]

Yes. Actually you don't need ELSE NULL but this way code is more readable.

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[SQLBill]

That should be the right syntax.

For further information, check out the BOL. Use the Index tab and enter CASE.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

Posting advice: FAQ481-4875