>>>The error is very explicit. You're missing THEN keyword before inner case starts.
>>
>>thank you
>
>You're welcome. Hopefully you're close to the solution now.


Almost :)

Now, how do I use the function? I'm calling it like this:

SELECT dbo.GetClaimItemStatus(clm_forwarded, cit_received, (select com_overduedays
															from companies
																inner join Clients on cli_comfk = com_pk
																inner join Claims subclaims on clm_clifk = cli_pk
																where subclaims.clm_pk = claims.clm_pk)) as statusfk
	from ClaimItems inner join Claims on cit_clmfk = clm_pk

and getting this error:


Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.GetClaimItemStatus", or the name is ambiguous.