Prev: Query
Next: Sequence
From: --CELKO-- on 9 Mar 2010 09:06
We have a unary minus in SQL:

SELECT CASE WHEN stinky_code = 'G6'
THEN -ABS(something_amount)
ELSE ABS(something_amount) END AS adjusted_something_amount,
stinky_code
FROM Encounters;

Those data element names need to be cleaned up and made less vague.
First  |  Prev  | 
Pages: 1 2
Prev: Query
Next: Sequence