Microsoft OLE DB Provider for SQL Server error '80040e14'

Line 1: Incorrect syntax near '789'.

/boilers/Blr_inspector_process.asp, line 63


This is the section that I have a problem with, but the line that's giving me the erroe has Badge_No in it:

' #### Update the HBC_Inspector record
strSQL = strSQL & "UPDATE HBC_Inspector SET "
strSQL = strSQL & "Contact_ID = " & Request.Form("contact_id") & ", "
strSQL = strSQL & "Inspector_EmployerDef_ID = " & Request.Form("inspector_employerdef_id") & ", "
strSQL = strSQL & "badge_no = '" & Replace(Request.Form("badge_no"), "'", "''")& "' "
strSQL = strSQL & " Where ID = " & Request.Form("ID")
ObjConn.Execute(strSQL)

Check whether single quotes are added for the char type fields and not for int type fields.
Error is for number 789. Check it is int or char type field.