HI,
I have to insert values from a text file that has text values with 1 to several trailling blanks. When I imported the file into Access, It removed the trailling blanks. So, i made a procedure that replaced the blanks by '|'. Then, in pl/sql, I used the folowing command :
T1 := REPLACE(t."Name_1", '|' ,CHR(32));

INSERT INTO TMP_TO_CRR_ADJUST_CUSTNUM VALUES (T1, t."Name_2", TO_NUMBER(t."New_NUM"));

The problem is that the trailing blanks are removed and I NEED THEM. I even used translate in place of REPLACE with the same result.

Is there another way to proceed,
Thank you very much,

Christian Cote