RE: Trick math for Query 400

["Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxxxxxxxxx>]

As many has mentioned, QM would be a better choice fo this.  Below is a simple 
statement to do it.

select (case  when a < b then 0 else a-b end) as c from myfile 


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Greg Wenzloff
Sent: Thursday, January 27, 2005 9:20 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Trick math for Query 400


I need a simple report to come out of Query but one column must not go
negative.    In the define results screen this field is defined as a simple
C = A - B but we do not want C to be negative. We would like to have a zero
instead.   A and B are both 7 digit numbers with no decimals.

Is there any trick math that would do this?

Thanks,
Greg   
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.