title: How would I determine if a varchar field in SQL contains any numeric characters?
body: <p>I'm working on a project where we have to figure out if a given field is potentially a company name versus an address.  </p>
  
  <p>In taking a very broad swipe at it, we are going under the assumption that if this field contains no numbers, odds are it is a name vs. a street address (we're aiming for the 80% case, knowing some will have to be done manually).</p>
  
  <p>So now to the question at hand.  Given a table with, for the sake of simplicity, a single varchar(100) column, how could I find those records who have no numeric characters at any position within the field?</p>
  
  <p>For example:</p>
  
  <pre><code>"Main Street, Suite 10A" --Do not return this.
  "A++ Billing" --Should be returned
  "XYZ Corporation" --Should be returned
  "100 First Ave, Apt 20" --Should not be returned
  </code></pre>
  
  <p>Thanks in advance!</p>