Thanks Norm, Ed and John,

The returned value is uniform (I am converting something like 8-184-33 into
08018400033) so I don't think that is the problem.

What I had to do is to format in a latter step. In some cases I like using UDFs in SELECTs because the code reads neater.

But the malfunction of TRIM surprised me!

Thanks again.

Alex


>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