That's because in your source table all of the records have the same length...you only have this problem when you do something (like trim()) that makes them have different lengths.


>hello Sergey
>
>that's not what i get, it only truncates the cursor field if i do for example an 'Alltrim(FldValue)' in the procedure, other then that i always get the fld length from the source table.
>
>>VFP uses first record in the table to determine the size of columns in the result. To prevent truncation of the calculated character fileds you've to pad result of that expression to the lenght you need. You may do that in your function or in the query itself.