title: SQL Update statement - syntax error near "SET"?
body: <p>I am generating the sql statement below based on some coldfusion logic, but it is erroring and I can't seem to find the cause, I have tried making many different modifications to it and nothing seems to be helping.</p>
  
  <pre><code>UPDATE MAIN_RECORDS 
  SET JONUM = NULL, 
  SET CUSTNAME = 'Super Sweet Name', 
  SET CONTACTDT = 02/28/2011, 
  SET ENGRECDT = 03/07/2011, 
  SET HOW_WR_DT = 03/07/2011, 
  SET COMM_DT = 03/29/2011, 
  SET FACAVALDT = NULL, 
  SET FAX_SUPDT = 03/07/2011, 
  SET LINENUM = 'CLPRO L6', 
  SET POLENUM = 'CLPRO 125 T T3', 
  SET REASON = '03/07/11 NO VAC FAC THIS IS THE WRONG INFORMATION IT WAS ON HERE TWICE', 
  SET REC_TYPE = 'H', 
  SET ORDER_TYPE = 'P', 
  SET CANCEL_ORDER = 'Y', 
  SET State_abbr = 'IL', 
  SET dbfk_state = 17, 
  SET xx_streetnumber = '2626', 
  SET xx_street = 'Fake St', 
  SET xx_city = 'NEWTON', 
  SET xx_class_of_service_ind = 'R', 
  SET xx_cellphone_ind = '1', 
  SET xx_assigned_phone = '3045653897', 
  SET xx_exchange_name = 'NEWTON', 
  SET XX_new_ref_code = '60', 
  SET xx_new_service_type = '11', 
  SET ORD_COMDT = 03/11/2011, 
  SET delivery_date = NULL 
  WHERE ordernum = '08824112' AND exchnum = '304565' 
  </code></pre>
  
  <p>Currently the error that management studio is giving me is:</p>
  
  <pre><code>Msg 156, Level 15, State 1, Line 1
  Incorrect syntax near the keyword 'SET'.
  </code></pre>