But the CHRTRAN() only take an expression. The first time I delimited the fields from the text file, I store it into database field. The fields now contain ~blah~~blah~.. if I use CHRTRAN() I had to hard code all the expression. How can I make it dynamic!!

>
>You better open text file with low-level functions, assign all file contetns to string variable, use CHRTRAN() to replace extra delimiter, save string into new txt file, and now you can run APPEND FROM safely.