title: SQL string value spanning multiple lines in query
body: <p><strong>UPDATE</strong>: the bio may contain apostrophes (see updated example)</p>
  
  <p>I have an SQL query that has a value which spans multiple lines and it causes the query to fail:</p>
  
  <pre><code>UPDATE User SET UserId=12345, Name="J Doe", Location="USA", Bio="I'm a
  bio that has an apostrophe, and I'm 
  spanning multiple lines!" 
  WHERE UserId=12345
  </code></pre>
  
  <p>In C# you can put an <code>@</code> before the string <code>Bio=@"..."</code>  in order to allow it to span multiple lines, but I'm not sure how the same thing can be achieved with SQL queries. How do you get a string to span multiple lines without having to do things like manually concatenating the strings: </p>
  
  <pre><code>Bio="I'm a"
  +" bio that has an apostrophe, and I'm"
  +" spanning multiple lines!" 
  </code></pre>