DECLARE @input_table VARCHAR(MAX)
DECLARE @SQL VARCHAR(MAX)

    SET @input_table = '2018_1_PROJECTED_INPUT_AUAP'
    SELECT @SQL = 'SELECT RIGHT('+@input_table+',4)'
    EXEC(@SQL)

--why doesn't this give me the last 4 characters of the input_table string?