Not directly using a SELECT statement. You can use
dynamic SQL
like:
set @sql = N'SELECT Column1 as ' + GetName(@myVariable) + N' FROM Table1'
exec sp_executesql @sql
But this is not suggestible as dynamic SQL has security implications/management issues.