title: determine DB2 text string length
body: <p>I am trying to find out how to write an SQL statement that will grab fields where the string is not 12 characters long. I only want to grab the string if they are 10 characters. </p>
  
  <p>What function can do this in DB2?</p>
  
  <p>I figured it would be something like this, but I can't find anything on it.<br>
  <code>select * from table where not length(fieldName, 12)</code></p>