>Hi,
>
>While using FP DOS I call a UDF from a SQL SELECT. I was surprised to find out that TRIM() does not work seem to work within the function! The code is this:
>
>SELECT FormatData(cX) AS cX FROM xx INTO CURSOR Y
>
>FUNCTION FormatData
>PARAMETER tcData
>lcNewData = ...
>RETURN lcNewData
>
>
>After getting funny results I paused within the function and
>tested through the DEBUG window that TRIM("aa ")+"." is not
>"aa." Does anybody know why? Have I gone through the looking glass?
>
In all probability, the width of the field returned from the UDF isn't uniform, and so the first resolution of the expression is seting up the maximum field legth, so that some values of the resultant cursor are truncated, or padded to the initial length of the field with trailing spaces.
Returning a variable length value from the UDF is the root of your problem.
>TIA,
>
>Alex