incorrect syntsx near 'set' (resolve)

[Goh]

 objCmd.CommandText = " UPDATE DataBase_T " & _
                    " SET Description = ' " & txtD1.Text & " ' , " &  _
                    " SET Qty = ' " & txtQ1.Text & " ' , " & _
                    " SET Unit_Cost = ' " & txtUC1.Text & " '  " &  _
                    " WHERE Description = ' " & describe & " ' and Qty = ' " & qty1 & " ' and Unit_Cost = ' " & uc & " ' and PR_NO = ' " & Label15.Caption & " '  "
 objCmd.CommandType = adCmdText
objcmd.Execute

wat could go wrong?

[Goh]

sorrie i mispost...there is this underscore after the 'update' statement

[Lightning]

You can leave all the set, only the first is nessesery