SQL: convert string to math operator

Question

This is what I am trying to do:

select Id, Operator form MathOperator 

Results:

ID | Operator
-----------
1  |  '+' 
2  |  '-'

*And somehow to do this:

declare @operator char(2)=  
     (select MathOperatorSymbol from MathOperator Where MathOperatorId = 1) 

select 1 @operator  2  -- should be as: select 1+2

Is it possible?

Answer 1

Use dynamic SQL

exec('select 1'+ @operator + ' 2')