>Hello Hugo
>
>Hello Panaji
>
>Thanks for your reply, but the problem is that i must include on where clause : and teste.conta = '11', because the Update statment run 1 time for all lines, like in SQL server and the on the update the field edebito is greather than zero
>Best regards
>Luis santos
Hi Luis,
I do not understand, did you check the value of SET EXACT? What stops you to put teste.conta = '11' (with set exact off) or LEFT(teste.conta, 2) = '11' (I think in my previous message I said RIGHT, sorry) in the where statement or in the case?
Hugo
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges