>>UPDATE vueOrdLines ; >>SET iQty = ; >> (SELECT MAX(iQty) from vueOrdLines) >>WHERE ... >>Yes, this is the exact syntax that I was trying. When I highlight the SELECT portion of the code and tell fox to execute the selection, it does return one number. I can run an almost identical query in SQL Server and it's perfectly happy. Unfortunately the info in the help file on the UPDATE-SQL command is really thin on the ground and the example is very simple. I suppose the crux of my question is can I embed a SELECT statement in an update statement? Maybe this is a really obscure requirement?