>>>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
If it's not broken, fix it until it is.
My Blog