>>Boris
>>
>>AdjLow and AdjHigh are numeric(6,4) fields in the table
>>
>>
>>Both of you
>>
>>The full SQL is
>>
>>Update TestResult set ECLScore = (Select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh) where SCN = @SCN
>>
>>
>As Boris and I suggest, just run the inner SQL separately first.
> and also check if you have a row where SCN = @SCN

Been there done that, how do you think I narrowed it down to the BETWEEN part - and yes, I have only one row in the TestResult table and SCN = @SCN.