title: regexp for digits AND commas
body: <p>This should be a lot easier than I think, but I've searching a trying for three hours now and nothing so here goes...
  I have a varchar2(6) column, so it can hold anything.  I'm trying to make a regexp to find the value that have numbers <strong>and</strong> commas.  Anywhere.<br>
  I've tried:</p>
  
  <pre><code>'^\d{1,5}[,]\d{1,5}$'
  '^\d+,+$'
  '^[0-9]{1,}[,]{1,}$'
  </code></pre>
  
  <p>And a myriad of other combinations, nothing.  I also tried</p>
  
  <pre><code>'^,$'
  </code></pre>
  
  <p>Just to see what happened, and nothing.  There's plenty of combinations in the table like</p>
  
  <pre><code>1,2,
  1, 2
  1 , 2
  ,1
  </code></pre>
  
  <p>I am using syntax like:</p>
  
  <pre><code>where regexp_like (REPLACE(column_name, ' ', ''), '^[0-9]{1,}[,]{1,}$')
  </code></pre>
  
  <p>To strip out white space and lower the distinct values.</p>
  
  <p>So can anyone point me in the right direction for a regexp to find values that are digits and at least one comma, in any order?</p>
  
  <p>Update - 
  Maybe this will clarify: I'm trying to find all values with at least one number and one comma. White space is irrelevant because I'm taking it out. No other characters than numbers and commas. The numbers and commas can be in any order.</p>
  
  <p>2nd update - Due to unfamiliarity with regexp I was interpreting ^ as the start of the expression and $ as the end of the expression. As in everything between ^ and $ is the regular expression.  I just saw where ^abc means match on everything starting with abc and abc$ means match on everything ending with abc.  </p>
  
  <p>TIA</p>