Microsoft Windows 10 Pro Build 19045

In this case, the string '1' can be converted to the integer value 1, so this SELECT statement will return the value 2. When the data types provided are integers, the + operator becomes addition mathematical operator, rather than a string concatenation.