DECLARE @number_of_years AS NVARCHAR(2) if @Method LIKE 'RSD_____%' or @Method LIKE 'RMS_______%' begin SET @number_of_years = (@yearto-@yearfrom)+1 end if @Method LIKE 'RSD_t%' begin if (SELECT SUBSTRING(@Method, 21, 1)) = '0' begin SET @number_of_years = (SELECT SUBSTRING(@Method, 22, 1)) end else begin SET @number_of_years = (SELECT SUBSTRING(@Method, 21, 2)) end end CAST (@number_of_years AS INT)