How do I evaluate a string expression in SQL Server?

Question

Given a string '100+200', how do I evaluate it?

I want to get 300 on output.

Answer 1

DECLARE @expression VARCHAR(MAX) = '100+200'
EXEC    (N'SELECT ' + @expression)

If it comes from a user, make sure it's sanitized