Update column value divisible by 100 Hello experts I need to update next column value with divisible by 100
You can use the Modulo operator, something along these lines:

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


HTH