title: CONTAINS unhappy with char(13)
body: <p>Why won't <code>SSMS</code> process this script for me?</p>
  
  <pre><code>DECLARE @containsReturn AS CHAR(500) = 
  'ME@ME.co.uk; 
  
  YOU@YOU.co.uk;'
  
  
  CREATE TABLE #x(ProblemColumn CHAR(500));
  INSERT INTO #x VALUES(@containsReturn);
  
  SELECT * FROM #X;
  
  
  UPDATE  #x 
  SET     ProblemColumn = REPLACE(ProblemColumn, char(13), '')
  WHERE   CONTAINS(ProblemColumn, CHAR(13))
  </code></pre>
  
  <p>I get this error, focused on the final <code>CHAR(13)</code> in the <code>UPDATE</code>'s <code>WHERE</code> clause:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 14<br>
    Incorrect syntax near 'CHAR'.</p>
  </blockquote>