Hi Dorris, (Dorris, Boris, very confusing!)

Are you sure you do not have any nulls in either AdjLow or AdjHigh?

Hugo

>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
>
>
>>>>Hi again, All
>>>>
>>>>I've got an SP that has the following
>>>>
>>>>

>>>>@TotEAP numeric(6,4)
>>>>@EAP numeric(7,5)
>>>>
>>>>**ListenEAP is already in my table from earlier update
>>>>
>>>>Select @TotEAP = (@EAP + ListenEAP)/2 from TestResult where SCN = @SCN  &&This works as expected
>>>>
>>>>Update TestResult set ECLScore = (Select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh)
>>>>

>>>>
>>>>AdjLow and AdjHigh are numeric(6,4).
>>>>
>>>>Here's the problem:
>>>>
>>>>The update doesn't happen with @TotEAP defined as a 6,4 (or even a 6,3) but it DOES work if @TotEAP is defined as a 6,2
>>>>
>>>>Nothing I'm reading in the help file is giving me any indication as to why it's not? Ideas?
>>>>
>>>>Thanks
>>>
>>>It depends how AdjLow and AdjHigh defined.
>>
>>The UPDATE looks a bit strange - do you want to update all rows in the table with the same constant value?
>>
>>E.g. what does select ECLScore from ScoreTable where @TotEAP between AdjLow and AdjHigh
>>
>>return?