case statement

[robertrao]

Hello,

I am using case statements like shown below. It throws an error

"Incorrect syntax near the keyword 'then'."

Can someone please help me write the correct syntax

Here, the Division table was used twice...

If its a medical student then we attribute the division value of the variable under admitting division(ACADADM)

If its a surgical student then we attribute the division value of the variable under performing division(ACADPERF)

CASE

WHEN (Type in('Medical') then ACADADM.Division

WHEN (Type in('Nonmedical') then ACADPERF.Division

Thnx a lot

END as MedType_ServiceLine,

[art297]

I would just get rid of the left parentheses that immediately follow the string 'when'. Let us know if that corrects the problem.

Art, CEO, AnalystFinder.com

[LinusH]

Since you are not utilising the in list you could simplify your code:
CASE Type
WHEN 'Medical' then...