Update column value divisible by 100

Question

Hello experts I need to update next column value with divisible by 100

Answer 1

You can use the Modulo operator, something along these lines:

UPDATE YourTable
SET NewBalance = Balance - (Balance % 100);

HTH