Check out this ... It May Work

Your Query

select @sql = 'Select tgt_module_' + right(@Module,1) + ' as Result from tbl_aud_dates where Month_Date = ' + char(39) + 'January-2005'...