>Yes, it trims automatically. I made changes to my code and it to be 10-12 Percent better.
>Though I am not very sure but I feel that that the following lines in my code are most time consuming.
>Can you suggest some improvement in this section please

Check where I showed you to use REST in my other response.

>
>

>For I=1 To m.nNumberofbillsincurrentfile && Loop to Separate Each Bill and we will Compress it later. There may be thousands of Bills 
>	Select Cursor_AllBills
>	Locate For Left(POS,9)='%%Page: 1' And Recno()>m.nBillend
>	nPageonestart=Recno()
>	Locate For Left(POS,9)='%%Page: 2' And Recno()>m.nPageonestart
>	nPageoneend=Recno()
>	Locate For Left(POS,9)='%%Page: 1' And Recno()>m.nPageoneend
>	nBillend=Recno()
>Select * From Cursor_AllBills Into Cursor Cursor_Splitedfile Where Recno()=>m.nPageoneend And Recno()<m.nBillend Readwrite
> * Rest of the code for compression etc.
>Endfor
>
>

>
>
>>>Sir, What is the reason of using varchar ?
>>
>>Copied from the original sample code posted.
>>
>>Don't use it myself,
>>the only virtue I know of is that it trims values automatically - simplifies chain concatenation
>>same storage length though
>>
>>In this particular case, C(254) should be good enough.
>>
>>I would even try a M as you don't need any index on this column, and your source data is CSV.
>>
>>As the file is huge, saving space on disk might also save execution time - to be tested though