title: Convert comma separated string to a list
body: <p>I want to pass a list of int's (comma separated) which is a field in my table</p>
  
  <blockquote>
    <p>ie. 1234, 2345, 3456, 4567</p>
  </blockquote>
  
  <p>to my <code>IN</code> clause in <code>WHERE</code>. But the list is a string (<code>VARCHAR</code>), and I'm comparing to an int field. Is there a way for me to convert the list to list of ints?</p>
  
  <p><code>Enterprise_ID</code> is <code>INT</code>
  <br>
  Path is a field in the table which is a comma separated string </p>
  
  <p>ie. 1234, 2345, 3456, 4567</p>
  
  <pre><code>SELECT *
  FROM tbl_Enterprise
  WHERE Enterprise_ID IN ( Path )
  </code></pre>
  
  <p>My database is Vertica.</p>