Hi Mike,

No, SET command can be used in T-SQL but not in SELECT. Here's the version for SELECT, assuming that @fystart is a loacl variable.

SELECT CASE WHEN (MonthNum + @fystart) = 13 THEN 12 
  ELSE ((MonthNum + @fystart - 1) % 12)  END AS RealMonth ...

>>
>>Try

SET @RealMonth = (@MonthNum + @fystart - 1) % 12
>>CASE @RealMonth WHEN 0 THEN 12 ELSE RealMonth END
>>

>>
>Uhh... OK, but how do I include that within my TSQL select command...
>
>Is it something like this:
>
>

>SET @RealMonth = (@MonthNum + @fystart - 1) % 12
>CASE @RealMonth WHEN 0 THEN 12 ELSE RealMonth END
>SELECT     STR(@RealMonth, 2, 0) + ' - ' + MonthName AS DisplayValue, STR(@RealMonth, 2, 0) AS cValue
>FROM         SelectLists
>

>
>... or does the SET... END statement belong within the SELECT somehow? (Pardon my neophite SQL status)