title: RegEx in SQL Server 2008
body: <p>I am not very familiar with RegEx and I have a scenario whereby I think the best option is to use RegEx. Actually, I have a column which hold values starting with a character, followed by numeric, ex. X10, Z49332, x0909.</p>
  
  <p>The regEx should validate;</p>
  
  <ul>
  <li>That the value start with a letter</li>
  <li>The following characters should be numeric </li>
  <li>No letter should be present after or in between the numerics</li>
  <li>The leading letter can be either Upper/Lower case</li>
  </ul>
  
  <p>I also read that SQL Server 2008 doesn't support RegEx and I am actually on a SQL Server 2008 platform. If so, how do I proceed?</p>
  
  <p>Can anyone help please?</p>
  
  <p>How do I check if the pattern of the values are being respected or not?</p>
  
  <p><strong>---EDIT---</strong></p>
  
  <p>Here is my actual query;</p>
  
  <p><a href="https://i.stack.imgur.com/yD9wY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yD9wY.jpg" alt="enter image description here"></a></p>
  
  <p>Which is returning all the records, instead of excluding the 1st one.</p>
  
  <p><strong>-- EDIT 2 : Following @Wolfgang Kluge response;</strong></p>
  
  <p>but still in vain! :(</p>
  
  <p><a href="https://i.stack.imgur.com/ycSzm.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ycSzm.jpg" alt="enter image description here"></a>
  Many thanks</p>