title: SQL select where column begins with Letters
body: <p>I have a table tbl1 with row of data:</p>
  
  <pre><code>ID       TIN     SSS
  10001    none    1000-20
  10002    69098   PRC
  10003    69099   INC
  </code></pre>
  
  <p>I want to query the the Legal_Doc_No of each ID. The value of each ID is either the TIN or the SSS column.</p>
  
  <p>How can I query the TIN and SSS column starting with letters (none) so that only values starting with numbers will be assigned to Legal_Doc_No</p>
  
  <pre><code>Select
  ID,
  'Legal_Doc_No' = case when TIN = Letter then SSS
   else TIN end
  from tbl1
  </code></pre>