title: Selecting rows where a column contains at least one character not in a whitelist
body: <p>I'm converting some sensitive data from a low-security encryption to a higher security encryption (specifically, from CFMX_COMPAT to AES with a 256-bit key). I intend to encode my AES-encrypted strings using Hex, and CFMX_COMPAT is extremely likely to use special characters, so finding records that aren't yet converted should be as simple as (pseudocode):</p>
  
  <pre><code>select from table where column has at least one character not in [A-Z0-9]
  </code></pre>
  
  <p>Is this possible in SQL? If so, how?</p>