SQL Update value to null

[anaylor01]

How do you update a value in a column to null? I am trying the statement below but that doesn't work.

      SQL1.ExecNonQuery2("UPDATE List Set List = 'NULL', Date = ? WHERE ID = ?", Array As String(DateTime.Date(now),i))

 

[Erel]

NULL is not a string. Your query should be:

UPDATE List SET List = NULL, ...