after doing some more checks, the following came out :

as actaully the from clause contained joins, the zero values were filtered out.

This means that the where clause is executed before...

The original datatypes were numeric (20,3) but are cast in the statement as float, so I tried to update them to numeric (20,10) first, and then also tried to update...