Hola Alejandro ---

Point One: Try to avoid using UDF's in SELECT statements.
Point Two: TRIM? Output len from the function should/must be uniform.


>
>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?
>
>TIA,
>
>Alex