Informix conversion on sum

[robert030975]

Hi okay I'm stuck

I have a script and would like to convert it to TSQL

Informix
select name, qty, inout, qty * ( inout || "1")
from table

Result

robert 1 - -1
Paul 2 + 2


does anyone know the TSQL for this?? Could it be case?

 

[SQLSister]

what does ( inout || "1") mean in informix?

"NOTHING is more important in a database than integrity." ESquared

 

[robert030975]

It must be power logic function??Case will do it but I was wondering if there is anything like this


Informix

select name, qty, inout, qty * ( inout || "1")
from table


to convert for case is

SELECT Name,
Qty,
Inout,
SUM(CASE WHEN Inout = '+'
THEN qty
ELSE (Qty * -1) END) AS TotalQty
FROM table


giving the reults as stated.