SET @RealMonth = (@MonthNum + @fystart - 1) % 12 >CASE @RealMonth WHEN 0 THEN 12 ELSE RealMonth END >>
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)