>UPDATE vueOrdLines ; >SET iQty = ; > (SELECT MAX(iQty) from vueOrdLines) >WHERE ... >>The error that I get is "function name is missing )". The help file just says column_name = expression1, it doesn't say what the expression can be, and the example is really simple. Is it possible to do this or am I just wasting my time?