SQL Server : CAST within EXEC (Dynamic SQL)

Question

I'm trying to dynamically compute a column name, however SQL Server doesn't let this happen. Is there a correct way of doing this?

Expected result

SELECT Column_1
FROM Table

Query

DECLARE @param AS INT;
SELECT @param = 1;

EXEC('SELECT Column_' + CAST(@param AS VARCHAR) + ' FROM Table');

Catch: the @Param needs to be int, for convenience of providing input.

Answer 1

Please use like this

DECLARE @param AS INT;
SELECT @param=1;
DECLARE @SQL AS VARCHAR(MAX) = 'SELECT Column_'+CAST(@param AS VARCHAR(5))+' FROM Table'
EXEC(@SQL);