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,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA