title: Request for sql oracle
body: <p>I have to write a request on a oracle.
  I have create a field which can contain 40 characters.
  I have to fulfield it with data from 3 fields from 3 differents tables.
  This is my rule:</p>
  
  <p>field1 = field2+ " " + field3 + " " + field4</p>
  
  <p>if my concatenation goes beyond 40 characters, this is what I have to do:</p>
  
  <p>-field1= field2 + "'" + trunc the field3 for the concatenation to length 40 with a minimum 8 for this field+ "'" + field4</p>
  
  <p>if it still goes beyond 40 characters, this what I have to do:</p>
  
  <ul>
  <li>field 1= Trunc the field2 for the concatenation to have 40+" "+ trunc the field3 to have 8+" " + field4</li>
  </ul>
  
  <p>I have not succeded to write a such request.</p>
  
  <p>Anyone to help.
  I'm very new on sql request!!</p>