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

Yes. I believe it's a standard SQL expression (hmm, how to say "expression" meaning "definition" ?), but I can verify. If you have Code Magazine article for VFP Focus issue when VFP9 was just released, there was a good article about new features in VFP-SQL. I forgot the author for a moment, let me find this article.

Ok, here is the article

http://www.code-magazine.com/Article.aspx?quickid=0404022

and the author is David T. Anderson