> For example:
> A1,B1,C1,D1,E1,F1 --> 'A1' || 'C1'
> A2,B2,C2,D2,E2,F2 --> 'A2' || 'C2'
> ...
should be:
A1,B1,C1,D1,E1,F1 --> 'A1' || substring('C1' from 2 for 1)
A2,B2,C2,D2,E2,F2 --> 'A2' || substring('C2' from 2 for 1)
I am careless.
-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn