title: Need to include AND in the Amount in words in Netsuite (SQL Language)
body: <p>I am including this formula in the netsuit's field default value: </p>
  
  <pre><code>CASE WHEN {total}=0 THEN 'ZERO' 
  ELSE TO_CHAR(TO_DATE(TO_CHAR(TRUNC({total}, 0)),'J'),'JSP') || ' ' || ' ' || ( 
    CASE WHEN LENGTH(TO_CHAR(REGEXP_REPLACE({total}, '^[0-9]+\.', ''))) = 1 THEN 
      TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, '^[0-9]+\.', ''), 0)*10),'J'),'JSP') || 'cents' 
    ELSE  TO_CHAR(TO_DATE(TO_CHAR(TRUNC(REGEXP_REPLACE({total}, '^[0-9]+\.', ''), 0)),'J'),'JSP')  || '&amp;nbsp;FILS ONLY' 
    END)
  END
  </code></pre>
  
  <p>If the amount is 6,703.20, than it prints:</p>
  
  <pre><code> SIX THOUSAND SEVEN HUNDRED THREE TWENTY FILS ONLY
  </code></pre>
  
  <p>I want to bring the AND in between to make it show like this: </p>
  
  <pre><code>SIX THOUSAND SEVEN HUNDRED THREE and TWENTY FILS ONLY
  </code></pre>
  
  <p>Can anyone help me please?</p>