>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.