title: T-SQL assign NULL to Text type field
body: <p>I try to execute next code to replace all empty strings to NULL, where column type is TEXT. But this code seems to do nothing.</p>
  
  <pre><code>UPDATE mytable SET textField = NULL WHERE DATALENGTH(textField)=0
  </code></pre>
  
  <p>What is right way here to null this column?</p>
  
  <p>UPD. OK, this is really work. It was just weird data showing of Embarcadero DBArtasian</p>