title: Select from column where value starts with 1
body: <p>i have a table T</p>
  
  <pre><code>id    val1
  a      199.87
  b      166.56
  c      100.67
  d      233.45
  e      177.23
  </code></pre>
  
  <ol>
  <li><p>I want to select those rows where <code>val1</code> starts with 1</p></li>
  <li><p>rows where <code>val1</code> starts with 19.</p></li>
  </ol>
  
  <p>Is there any way of doing this in SQL Server.</p>
  
  <p>The data type of val1 is float.</p>