title: What is the Null Character literal in TSQL?
body: <p>I am wondering what the literal for a <a href="http://en.wikipedia.org/wiki/Null_character" rel="noreferrer">Null character</a> (e.g. '\0') is in TSQL. </p>
  
  <p><strong>Note:</strong> not a NULL field value, but the null character (<a href="http://en.wikipedia.org/wiki/Null_character" rel="noreferrer">see link</a>). </p>
  
  <p>I have a column with a mix of typical and a null character. I'm trying to replace the null character with a different value. I would have thought that the following would work but it is unsuccessfull: </p>
  
  <pre><code>select REPLACE(field_with_nullchar, char(0), ',') from FOO where BAR = 20
  </code></pre>