>>>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