>>>>>>select(padr(myCharFiled, 15, chr(0)) && pick the right character here.
>>>>>
>>>>>I will try it. Thank you.
>>>>
>>>>Try chr(0)
>>>
>>>You know what I thought. I can probably easily write my own procedure to store the values into the text file. And there, I can control the format and layout any way I want to.
>>
>>For not very big cursors, it will be a good approach. For big files it may be slow (say, with 2MB files and up).
>
>I can't think of the cases where this cursor will have more than 1000 or 2000 records. So this will be doable; I think.
Ok, good then. I recommend to use low-level file functions rather that loading all into one string and saving at the end.
If it's not broken, fix it until it is.
My Blog