Ok to keep it simple lets assume I have 2 columns:
Im creating a view so bare in mind this is part of my SELECT clause. I need...
IF (QTY <> 0 AND TRANSTYPE='ADJ' then QTY = QTY * -1)
I dont think I can do this in a CASE statement?