title: substring, after last occurrence of character?
body: <p>I need help with this problem:
  I have a column named phone_number and I wanted to query this column to get the the string right of the last occurrence of '.' for all kinds of numbers in one single sql query. </p>
  
  <p>example #:</p>
  
  <p>515.123.1277</p>
  
  <p>011.44.1345.629268</p>
  
  <p>I need to get 1277 and 629268 respectively.</p>
  
  <p>I have this so far:
  select phone_number, 
  case when length(phone_number) &lt;= 12
  then 
  substr(phone_number,-4)
  else 
  substr (phone_number, -6) end
  from employees;</p>
  
  <p>This works for this example, but I want it for all kinds of # formats.</p>
  
  <p>Would be great to get some input.</p>
  
  <p>Thanks</p>