title: How to set out an sql string without getting newline in constant error
body: <p>This is daft but I am declaring a sql string for an  sqlcommand and I am having to write it all on one line as</p>
  
  <pre><code>string strSQL = "SELECT [Year],[Week No],StartDate,EndDate,Dept,[Clock No],RTRIM(Name)+' '+   RTRIM(initial) as Name,[Own Hours],[Other Hours],[Total Hours],[OT Premium] FROM [Wages].[CHHours] Where [Year]=@WageYear and [Week No]=@Week Order by  [Year] DESC, [Week No] DESC,Dept,[Clock No]" ;
  </code></pre>
  
  <p>because otherwise I get the newline in constant error but this looks REALLY ugly and hard to read. In vb it would use the  &amp;_ to continue and as c# is not white space sensitive (I thought) I should write it like this</p>
  
  <pre><code>string strSQL = "SELECT [Year],[Week No],StartDate,EndDate,Dept,[Clock No],
                RTRIM(Name)+' '+ RTRIM(initial) as Name,[Own Hours],[Other Hours],
                 [Total Hours],[OT Premium] 
                 FROM [Wages].[CHHours] 
                 Where [Year]=@WageYear and [Week No]=@Week 
                 Order by  [Year] DESC, [Week No] DESC,Dept,[Clock No]" ;
  </code></pre>
  
  <p>or do I have to do to</p>
  
  <pre><code>string strSQL = "SELECT [Year],[Week No],StartDate,EndDate,Dept,[Clock No],";
  
  string strSQL = strSQL+" RTRIM(Name)+' '+ RTRIM(initial) as Name,[Own Hours]";
  
  string strSQL = strSQL+",[Other Hours],[Total Hours],[OT Premium] ";
  
  string strSQL = strSQL+"FROM [Wages].[CHHours] ";
  
  string strSQL = strSQL+" Where [Year]=@WageYear and [Week No]=@Week ";
  
  string strSQL = strSQL+"Order by  [Year] DESC, [Week No] DESC,Dept,[Clock No]" ;
  </code></pre>
  
  <p>Which strikes me as something very old!</p>
  
  <p>What is the best way please
  Ian</p>