In addition to solution1 by
RossMW[
^] i'd suggest to do it in more efficient way by using
modulo[
^].
DECLARE @tmp TABLE(myNumber INT)
INSERT INTO @tmp (myNumber)
VALUES(81), (10), (40),(71), (21),
(31), (41), (30), (90), (61),
(50), (11), (20), (91), (60)
SELECT myNumber, CASE WHEN myNumber % 10 = 0 THEN myNumber + 2 ELSE myNumber + 1 END AS NewMyNumber
FROM @tmp
Result:
myNumber NewMyNumber
81 82
10 12
40 42
71 72
21 22
31 32
41 42
30 32
90 92
61 62
50 52
11 12
20 22
91 92
60 62