True ....
but why do it the traditional way when a perfectly good convoluted way SHOULD work?    ... :)

Thnx Trey. I agree with you. As it happens, I have been experimenting since I have a personal goal of proving to my clients that VFP is a better tool to use for most day-to-day adjustments against data in their SQL database than is the MS Query Analyzer and that VFP has use of syntax that is virtually identical to many of the SQL commands you'd use in the Query Analyzer therebye eliminating learning new commands to work in VFP instead of QA. Naturally, some SQL Server coding is not directly translateable and I guess this is just such an example.

BTW: My original syntax had been:

UPDATE moneyfields SET moneyfields.ttladjusts = ;
(SELECT query.adjusts FROM query WHERE query.control = moneyfields.control)

but that didn't work either so I guess we'll stick with convention for now. Thnx again for your support. /psb