Hi

I have a select that includes the following

sl.maxStock - (sl.ShelfQty + sl.SupOrdrQty - sl.CustOrdQty) AS Needed

What i want is this calc value or 0 if it is less than zero, i.e. Needed or
0 whatever is the higher. Is this possible?

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd