title: sqlserver pattern matching on a particular variable
body: <p>I need to implement pattern matching using sqlserver...</p>
  
  <p>These are the following conditions-</p>
  
  <ol>
  <li>The first letter of the word should start with a character.
  2.It can be upper or lower case
  3.The following characters after the 1st chacter  can by numbers 1-9 or any valid characters or underscore..</li>
  </ol>
  
  <p>Basically I need to implement this regular expression logic in sqlserver</p>
  
  <pre><code>'/^[a-zA-Z][a-zA-Z0-9_]*$/
  </code></pre>
  
  <p>I'm sure this will work </p>
  
  <p>ie;</p>
  
  <p>select var_1 from table_1
  where var_1 like [a-z] but not sure how if all the logic can be implemented </p>