Re: Help with Calculation

bobsacomano_at_yahoo.com wrote:
> Ultimately what I want to do is identify all the order numbers as
> greater or less than 1000. I can add that calculation once I figure
> out how to get this order total calculation figured out. Apologies for
> not being more specific.

SELECT SIGN(DECODE(some_value - 999, 1, 1, 0)) FROM dual;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)