Hi Naomi,

see my comment below. I'm not seeing how to fix this from my google searches.

>Here is how you can re-write the ClaimItemStatus function to be inline table-valued
>

>create function dbo.ClaimItemStatus
>( 
>   @ClaimItemPk int,
>    @Start Date,
>    @End Date,
>    @DayLimit Int
>) 
>RETURNS TABLE
>AS 
>
>with cte as (select case when @Start IS NOT NULL and @End IS NOT NULL 
>          THEN 'Settled'
>         WHEN @Start IS NOT NULL 

**** I'm getting a syntax error on the case here: Expecting AND, OR, or THEN****
>                  case when @DayLimit > (select count(*) .... ) -- here we can either use direct query or your scalar function - I prefer direct count

>                      THEN 'OverDue'
>                  else
>                       'Pending' 
>               END
>        ELSE -- what else is not covered ?
>           'Unknown'
>      END as StatusDescr)
>
>select StatusDescr, case StatusDescr WHEN 'Settled' then 2 when 'Pending' then 4 when 'OverDue' then 3 when 'Unknown' then 5 end as [Status]
>from cte
>
>GO
>