>>>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?
I gave you the whole query in one of my replies.
The derived query is a select statement inside the select, e.g.
select myTable.*, myDerived.* from myTable inner join (select ... ) myDerived on myTable.Field = myDerived.Field
Here is my reply with the code for your case
Re: Functions in a select Thread #
1341594 Message #
1341617
If it's not broken, fix it until it is.
My Blog