SQL Server Update command syntax :(

[xoro]

I am having a similar issue with mine. I've gotten it to work if there are no spaces or characters such as "#" or "/" in the fields I am updating, but that isn't very often.

If anybody knows the answer to this problem I'm sure we would both appreciate it. My statement looks like this:

Dim strSql As String = "UPDATE News SET Headline='" & strHeadline & "', Message='" _
                & strMessage & "', Post_Date='" & strDate & "' WHERE Headline='" _
                & newsListBox.SelectedItem.ToString() & "'"