Dynamically Select Column

Hey all. I'm trying to create a stored proc that will update a variable column, depending on the parameter I pass it. Here's the stored proc:








CREATE PROCEDURE VoteStoredProc


(


@PlayerID int,


@VoteID int,


@BootNumber nvarchar(50)


)


AS





DECLARE @SQLStatement varchar(255)


SET @SQLStatement = 'UPDATE myTable SET '+ @BootNumber+'='+ @VoteID + ' WHERE (PlayerID = '+ @PlayerID +')'





EXEC(@SQLStatement)





GO








I get the following error:





Syntax error converting the nvarchar value 'UPDATE myTable SET Boot3=' to a column of data type int








The update statement is good, because if I use the stored proc below (hard-coded the column), it works fine.





CREATE PROCEDURE VoteStoredProc


(


@PlayerID int,


@VoteID int,


@BootNumber nvarchar(50)


)


AS





UPDATE


myTable


SET


Boot3 = @VoteID


WHERE


PlayerID = @PlayerID


GO








Is there a way to dynamically choose a column/field to select from? Or is my syntax incorrect..?


Thanks!