title: How can I perform a regex/text search on a SUPER type?
body: <h2>What I'm doing now:</h2>
  <ul>
  <li>I have a table with one field that is a json value that is stored as a super type in my staging schema.</li>
  <li>the field containing the json is called <code>elements</code></li>
  <li>In my clean table, I typecast this field to <code>VARCHAR</code> in order to search it and use string functions</li>
  <li>I want to search for the string <code>net</code> within that json in order to determine the key/value that I want to use for my filter</li>
  <li>I tried the following:</li>
  </ul>
  <pre class="lang-sql prettyprint-override"><code>select 
      elements
      , elements_raw
  from clean.events
  where 1=1
    and lower(elements) like '%net%'
    or strpos(elements,'net')
  
  </code></pre>
  <h2>My output</h2>
  <ul>
  <li>When running the above query, I keep getting an empty set returned.</li>
  </ul>
  <h2>My issue</h2>
  <ul>
  <li>I tried running the above code and using the <code>elements_raw</code> value instead but I got an issue :<code>ERROR: function strpos(super, &quot;unknown&quot;) does not exist Hint: No function matches the given name and argument types. You may need to add explicit type casts.</code></li>
  <li>I checked the <a href="https://docs.aws.amazon.com/redshift/latest/dg/r_SUPER_type.html" rel="nofollow noreferrer">redshift super page</a> and it doesn't list any specifics on searching strings within super types</li>
  </ul>
  <h3>Desired result:</h3>
  <ul>
  <li>Perform string operations on super field</li>
  <li>Cast super field to a string type</li>
  </ul>