spaces causing problems in UPDATE sqlcommand

[Matrix.net]

anyone have an idea as to why I'm getting errors that seem to be caused by spaces when I try to do an update command such as :

Dim myConnection As SqlConnection
myConnection = New SqlConnection("Data Source=SQL2KDB;Initial Catalog=OnlineJobs;Integrated Security=SSPI;")
Dim mycommand As SqlCommand
mycommand = New SqlCommand("UPDATE AvailableJobs SET Title = " & title & ", Supervisor = " & supervisor & " , Department = " & department & ", JobCode = " & jobCodeModified & ", Description = " & description & ", Requirements = " & requirements & ", PostedDate = " & postedDate & ",PostingEnds = " & postingEnds & ",ActiveOrPosted = " & activeOrPosted & " WHERE JobCode = " & jobcode, myConnection)
myConnection.Open()


mycommand.ExecuteNonQuery()
myConnection.Close()

it keeps saying there is a syntax error near ____ , the syntax error occurs wherever there is a space in the strings variables I'm sending in

[pclement]

String values must be enclosed in single quotes when using variable insertion in a SQL string. For example:

"UPDATE AvailableJobs SET Title = '" & title & "'"

You can avoid this issue using Command Parameters instead of variable insertion.

[Matrix.net]

oh okay thanks , jeeez I always forget that