>>>>The alternative would be to select into an empty field and then run the function afterward via a SCAN. Would that be preferable?
>>>>
>>>I would guess that derived table solution would be quicker than select + update using the original function, but you may want to test it to be sure.
>>
>>What exactly do you mean by a derived table?
>
>BTW, we already discussed derived tables once
>
>Re: 2 level SQL Thread #1317489 Message #1317491

So then, by the term "derived table" you mean a select within a select??