You Sir are a genius, and I am an idiot - so often the simplest of things....!!!!

Here is my complete SQL statement - is it because of where the CASE statement is in the query?

DECLARE @PeriodDuration INTEGER SELECT @PeriodDuration = rdowner.V_GLOBAL.PeriodLength

FROM ...