RE: MAX() Function

Posted in 2003

Colin Bull — Wed, 13 Aug 2003 12:13:38 +0100 — source: Usenet: comp.databases.informix

Sounds like you have defined phonebid as a char type instead of numeric. Colin Bull > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Dave Hill > Sent: 13 August 2003 08:53 > To: informix-list@iiug.org > Subject: MAX() Function > > > Hi World, > > Can anybody help and make suggestions why the max function is not > working in my sql? > > select max(p_bid) phonebid > from bid > where batch = $BATCH > into temp t2 with no log; > > What is happening is if a client bids '8 the max function does not > pick up a higher bid until you get to '81!! This is really confusing > me. This is the same no matter if you start with '6 it then wont pick > a bid up as max until '61 etc.. > sending to informix-list