title: Teradata 15: parsing a string
body: <p>The task is to scan a string varchar value, which can be null or 3 to N symbols length, and find out if it contains a specific combination in it.</p>
  
  <p>Example:
  Find if string <code>A001G002F001H003Z701</code> contains <code>F001</code> or <code>B004</code> or <code>J005</code></p>
  
  <p>Which solution for this task is the most efficient? thx</p>