how to assign null to a field in sqlite <p>I would like to assign <code>null</code> to a field in SQLite but am not getting anywhere with this:</p> <pre><code>update t set n=null where n=0; </code></pre>