title: grouping the same value in upper case and lower case with select query
body: <p>In the below table <strong>InputParameterName</strong> column contains <strong>Product1</strong> ( <strong>P</strong> upper case) and <strong>pRoduct1</strong> ( <strong>R</strong> upper case).</p>
  
  <p>Table1 : </p>
  
  <pre><code>InputParameterName  Period  PeriodInput
  Product1             2017   25704
  Product1             2018   25704
  pRoduct1             2017   16
  pRoduct1             2018   16
  pRoduct1             2017   57.6
  pRoduct1             2018   57.6
  pRoduct1             2017   40.5
  pRoduct1             2018   40.5
  </code></pre>
  
  <p>My query: </p>
  
  <pre><code>SELECT InputParameterName, Period, SUM(CAST(PeriodInput AS FLOAT)) PeriodInput  
  FROM Table1         
  GROUP BY InputParameterName, Period
  </code></pre>
  
  <p>Result : </p>
  
  <pre><code>InputParameterName  Period  PeriodInput
  Product1                    2017    25818.1
  pRoduct1                    2018    25818.1
  </code></pre>
  
  <p>In the result you can see InputParameterName column has <strong>Product1</strong> ( <strong>P</strong> upper case) and <strong>pRoduct1</strong> ( <strong>R</strong> upper case).</p>
  
  <p>Is there any way to get both as same, either <strong>Product1</strong> or <strong>pRoduct1</strong> (exact values without applying any character case conversion) ?</p>