title: DB2 SQL Case Insensitive
body: <p>I'm executing the below DB2 SQL via SQL Server (so needs to be in DB2 SQL):</p>
  
  <pre><code>exec ('
    select 
      TRIM (vhitno) AS "Item",
      TRIM (mmitds) AS "Description",
      TRIM (SUBSTRING (vhitno,12,4)) AS "Size",
      vhalqt AS "Available"
    from m3fdbtest.oagrln
      left outer join m3fdbtest.mdeohe 
        on vhcono = uwcono 
          and vhcuno = uwcuno 
          and vhagno = uwagno 
          and vhitno = uwobv1
      left outer join m3fdbtest.mitmas 
        ON vhcono = mmcono 
          AND vhitno = mmitno
      where uwcono = 1
        and uwstdt &gt;= ?
        and uwlvdt &lt;= ?
        and uwcuno = ''JBHE0001''
        and uwagst = ''20''
        and (vhitno LIKE ''%'' || ? || ''%''
          or mmitds LIKE ''%'' || ? || ''%'')',
    @From, @To, @Search, @Search) at M3_TEST_ODBC
  </code></pre>
  
  <p>However, DB2 is case sensitive - how do I make the two LIKES on mmitds and vhitno case insensitive?  </p>