Great question.

The precedence of operators, in that case, will make all the difference.

Since it's math, if we use parenthesis, we'll get a different result as expected.

SELECT '2' + '3' * 1 -- = 5

GO

SELECT ('2' + '3') * 1 -- = 23

GO

A good way to start the week. 😉

Best regards,