title: Comparing two different strings in SQL that are in a different order
body: <p>I have two columns in two different tables and want to compare the string values.  For example:</p>
  
  <pre><code>TABLE1.COLUMNA value = ABC, DEF, XYZ
  TABLE2.COLUMNB value = ABC, XYZ, DEF
  </code></pre>
  
  <p>I want to return results when the two string are not equal.  In this case, I don't care about the order all I care about is that the two values are equal.  So the above example the two strings are equal. </p>
  
  <p>These two strings would not be equal</p>
  
  <pre><code>TABLE1.COLUMNA value = ABC, DEF, XYZ
  TABLE2.COLUMNB value = ABC, XYZ, LMN
  </code></pre>
  
  <p>FYI...I am putting this query into a tool that only supports SQL queries only.</p>
  
  <p>Any help would be appreciated.</p>