Concatenation Operator in ACE Reports

[ufobaby]

hi all,

am using the concatenation operator || in ace reports

============
Database cpcprd END

Define ....
Input ....
Output ....

select
a.txt_idcode[12,13]||'/'||a.txt_idcode[10,11]||'/20'||a.txt_idcode[8,9],
a.txt_idcode[12,13]||a.txt_idcode[10,11]||a.txt_idcode[8,9]
,a.txt_idcode[14,19]
from acctents a
where
a.nbr_account = "4010056492"
and typ_drcr = "D" and typ_idtype = "S"
and a.cod_product = "CCHK" and
a.dat_acentry = "090902"
into temp act;

select * from act
End

Format .....
=====================
This gives a typographical error (at the pipe)????? works fine with query module in informix

Pls help , am really stuck with this problem :-(


Niraj