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