case t.[Year] when year(GETDATE()) | (year(GETDATE())+1) isnumeric( t.[Year]) then t.[Year] when year(GETDATE()) & (year(GETDATE())+1) isnumeric( t.[Year]) then t.[Year] end
case When year(GETDATE())=t.[year] OR (year(GETDATE())+1) = t.[year] then t.[year] else year(GETDATE()) end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)