需要在Netsuite (SQL语言)中包含和在字数中

Question

我将此公式包含在网服的字段默认值中：

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')  || ' FILS ONLY' 
  END)
END

如果金额为6,703.20，则打印：

 SIX THOUSAND SEVEN HUNDRED THREE TWENTY FILS ONLY

我想把和放在中间，让它像这样显示：

SIX THOUSAND SEVEN HUNDRED THREE and TWENTY FILS ONLY

有谁能帮帮我吗？