>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!!
>
Firstly, I didn't advise you to use database field. I actually told you about string variable. Secondly, if you need to replace more than one sequential character you could (as Cetin said) use STRTRAN(). This way you will get it 'dynamic'.
Edward Pikman
Independent Consultant