Ronaldo,

r> What's the inicial value of a variable?
r> I can do this whitout make "SOMA = 0" in the inicial part of code?
r> "SOMA = SOMA + POWER((NOTA_PROVA - MEDIA),2);"

if I was you I would avoid any chance of discovering it the hard way,
i. e. I always initialize everything.

AFAIK variables in stored procedures are not initialized; I seem to
recall even that they keep the value from previous calls to the
stored procedure, but I'm not sure.

Ciao
--
Nando mailto:nandod@...