Can anyone Debug a sql statement

[needhelpso]

This statement is not working and I think it is due to syntax....I think I am missing a " or something...

strUpdateStatement = "UPDATE Employee_Info SET PayPeriod='" & dropdownlist2.selecteditem.value & "', Hours='" & HourlyRate.Text & "' WHERE Employee_ID=12

Possibly missing a couple of quotes since I have rewrote it a couple of times

 

[Kenos]

Place a double quote at the end of your statement.