The code I provided was written in assumption that fields are character not numeric. Using VAL(NUM1)+Val(NUM2) will produce incorrect result.
>Thanks Sergey,
>
> But I forgot to tell you that num1 and num2 were the characters not numeric fields, and I already used VAL(NUM1)+Val(NUM2) , ok but at the end
>all records were deleted from mytable anyway, I don't know why ?
>
>Paul
--sb--