title: SQL query to exclude numbers, brackets or special characters at the end of a name
body: <p>I'm trying to exclude all names with numbers in it, but still include certain special characters like:
  ()-'</p>
  
  <p>So far, i've got this query:</p>
  
  <p>SELECT FirstName FROM Client WHERE FirstName NOT LIKE '%[^0-9]%';</p>
  
  <p>This excludes most names with numbers in it, however, a few like the following are still coming through (not being excluded):</p>
  
  <p><a href="https://i.stack.imgur.com/YMg5w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YMg5w.png" alt="enter image description here"></a></p>
  
  <p>How do i exclude these from above, but still keep rows that look like the ones below:</p>
  
  <p><a href="https://i.stack.imgur.com/Epcgm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Epcgm.png" alt="enter image description here"></a></p>
  
  <p>Thank you in advance!</p>