I am trying to use the case expression to change a number from positive to
negative or vice versa.

If QTY = 50 I want to return 50 when TRANS_TYPE = 'A' and -50 when
TRANS_TYPE = 'B'

If QTY = -10 I want to return -10 when TRANS_TYPE = 'A' and 10 when
TRANS_TYPE = 'B'

Psuedo code here:

SELECT
(CASE   TRANS_TYPE
WHEN 'A' THEN QTY
WHEN 'B' THEN ??? (here is where I want to return negative if the number is
positive or positive if the number is negative)
END)as QTY,
TRANS_TYPE,
FROM TABLE1

SQL has a unary minus operator since the SQL-86 standards.

CASE trans_type WHEN 'A' THEN qty ELSE -qty END

Thanks to all.

Is it appropriate to respond back to the newsgroup to say your issue is
resolved or is that considered unnecessary noise.

Show quoteHide quote

It is a nice touch.  Most of us wonder if the advice given is actually of
any value :)

Show quoteHide quote

Resequence column
Linked Server Yields inconsistent results
The value of @@Error after Select statement
How to check existing data with a relationship in code. How to drop a relationship in code.
changing SQL syntax