multiple case inside of each other

[sqlfzk]

Hi, how I can create a column with case when I need another case in "then"; here is my problem: fyi, tyear is 4 diget and year is 2 diget; what I'm doing wrong?

[Year]= case when isnull(t.status,'') <> 4   
then case when rigth(t.[Year],2)< rigth(t.[tYear],2)
then 
when t.[Year] <= 12 
then '20'+t.[Year] 
else '19'+t.[Year] 
end 					
else t.[tYear]
end
from table

[Rabbit]

Line 2, you spelled right incorrectly.

Line 3, you need an expression after your then, you can't go directly into another when regardless of whether or not you're using nested cases.

[sqlfzk]

oops, thanks for you info.

[NeoPa]

The important point to note here is that you can happily nest CASE statements as long as you follow the syntax correctly.