• Thank you Mr.Ron. It worked like a champ. I just had it tweeked a little bit to suit my requirement. Yes. It is indeed an odd requirement to store a comboYear String.

    DECLARE @BegYr INT = 2013

    DECLARE @EndYr INT = 2015

    DECLARE @Diff INT

    SELECT @diff = @EndYr - @BegYr

    DECLARE @E INT

    DECLARE @a VARCHAR(10)

    DECLARE @Z VARCHAR(10)

    SET @E = @BegYr

    IF @Diff = 3

    BEGIN

    SET @Z = (SELECT SUBSTRING(CAST(@E AS VARCHAR(4)),LEN(CAST(@E AS VARCHAR(4))),LEN(CAST(@E AS VARCHAR(4)))))

    WHILE @E < @EndYr

    BEGIN

    SET @E = @E + 1

    SET @a = (SELECT '/' + SUBSTRING(CAST(@E AS VARCHAR(4)),LEN(CAST(@E AS VARCHAR(4))),LEN(CAST(@E AS VARCHAR(4)))))

    SET @Z = @Z + @a

    END

    SELECT @Z

    END

    ELSE

    BEGIN

    SET @a = (SELECT SUBSTRING(CAST(@BegYR AS VARCHAR(4)), 4, 1) + '/' + SUBSTRING(CAST(@EndYR AS VARCHAR(4)), 4, 1))

    Select @a

    END