title: Sybase - Wildcard % behaves differently
body: <p>In Sybase IQ DB, I was trying to get the table with name 'count_appenv' from SYSTAB table. </p>
  
  <p>I tried to get the table list from my code by passing the table format like 'count%%appenv'. I expected the 'count%appenv' and 'count%%appenv' to behave in similar way. </p>
  
  <p>But, 'count%%appenv' required atleast 2 characters in the respective wildcard's place but here I have only '_' in the place of '%%', so this dint fetch me the table 'count_appenv'. But, when I tried like 'count%%ppenv' or 'count%%env', it worked.</p>
  
  <p>Why this difference when using '%' and '%%'?</p>
  
  <p>I have this issue when I pass this table format to a stored proc.
  The stored proc executes this query </p>
  
  <pre><code>SELECT table_name 
    FROM SYSTAB 
   WHERE (table_name LIKE @mytable)
  </code></pre>
  
  <p>where @mytable is the parameter I use to get the table name format.</p>