title: SQL / Celonis - where field only contains just numeric, remove anything else
body: <p>In a field I want to keep those where it is only a number between 100000 and 999999</p>
  <p>This field has a mixture of numeric, alphanumeric, alphabet characters.</p>
  <p>This function will keep if there is a number in a field e.g. keep abc123 where I would want that removed</p>
  <pre><code>where some_column NOT LIKE '%[^0-9]%'
  </code></pre>
  <p><strong>Additional - Celonis Equivalent ?</strong></p>
  <p>Gordon has kindly provided SQL Server coding to do this exactly as intended.</p>
  <p>I was hoping this would work in <strong>Celonis</strong> but the try_convert function is not supported. Is there another method?</p>
  <pre><code>where try_convert(int, some_column) between 100000 and 999999
  </code></pre>