Hi Nadya,

OK I got it. Thanks,

Doron

>>Hi Nadya,
>>
>>I see where you are coming from. You do a SELECT * but if you have one field with exprssion you will need to enter list of fields isn't that. If you have a
>>field with one exprssion and you call a UDF to handle that, you may losse optimization in here. I am talking about RushMore.
>>
>>Regards,
>>
>>Doron
>
>
>Doron,
>
>Perhaps you misunderstood, what I was trying to say: No, I never use UDF in a SELECT STATEMENT (though I may), I use UDF to construct a string, which when would be used in Select Statement :) In other words, my program would be like this:
>

>********************************************************************
>*  Description.......: MapRefStr
>*  Calling Samples...: 
>*  Parameter List....: tcOperationType
>*  Created by........: Nadya Nosonovsky 04/02/2001 04:21:34 PM 
>*  Modified by.......: Nadya Nosonovsky 04/04/2001 11:34:54 AM
>********************************************************************
>lparameter tcOperationType
>local lcRetStr, lcJoinCondition, lcAdditions, lcWhere
>lcRetStr='space(1) as ModiType, '+ ;
>         'AssrID, Apn, ParcelID, '+ ;
>         'MapNum, WardNum, BlockNum, LotNum, UnitNum, MapData, MapRef, '+ ;
>         '.f. as Posted, ctot([]) as PostTime, 0 as Error, '
>if !empty(m.tcOperationType) and m.tcOperationType="MAPREF"
>     lcAdditions='PropMstr.ccode, PropMstr.FY, PropMstr.town, '+;
>                 'AssrMstr.ModiDate, [ASSRMSTR] as ModiTble, space(1) as APNed, '+ ;
>                 'space(1) as Parsed, space(1) as PclIDEd'
>else
>     lcAdditions='PropMstr.*, space(25) as NewMapref, space(1) as MapRefEd, '+ ;
>                 'space(8) as ModiTble, "P" as Source, [ ] as Matched'
>endif
>lcJoinCondition = ' FROM PropMstr INNER JOIN ASSRMSTR ON PropMstr.PropID=AssrMstr.PropID'
>lcWhere=[ where Complevl='P' and PropMstr.town=']+ojc.Town + ;
>        [']+iif(!empty(oJC.FY),[ and PropMstr.FY=']+oJC.FY+['],"")+" and InActvFl'A'"
>return m.lcRetStr+m.lcAdditions+m.lcJoinCondition+m.lcWhere

>
>And I put MaprefStr() in SelectCmd1Exp. Now the code does:
>

>selectCMD1 = evaluate(SelectCMD1Exp), so this long string would be produced
>
>select &SelectCMD1 ;
>       &SelectCMD2 ;
>       &Into