I have num1 and num2. And I am subtracting num1 - num2
e.g num1 - num2
1000 - 500 = 500

but what if values are:
case1 1000 - -500 (num1 pos & num2 neg value) ??
case2 -1000 - -500 (num1 neg & num2 neg value) ??
case3 -1000 - 500 (num1 neg & num2 pos value) ??

Can any one solve all 3 above cases in SELECT statement.

Thanks