I want to know how to add percentage symbol(%) to my final sql statment column names in stored procedure, query below
set @finalSelect = 'SELECT NAME,State,TotalPop, ' + @parameter +'_Pop%
Result: NAME, State, TotalPop, White_Pop% (column names)
When I add % symbol it throws an error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '%'.
Any idea how to add percentage(%) symbol??