RE: [CFTALKTor] High and low's

[Marc Campeau]

Try Union   Like:   SELECT (     SELECT FieldA WHERE FieldA > FieldB AND FieldA > FieldC   UNION ALL     SELECT FieldB WHERE FieldA < FieldB AND FieldB > FieldC   UNION ALL     SELECT FieldC WHERE FieldA < FieldC AND FieldB < FieldC   ) AS maxField FROM FieldTable....     Marc Campeau   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Green Sent: Tuesday, May 07, 2002 10:37 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] High and low's Is there an easy ( ha, ya right!) way to find the highest and lowest values within a single record when looking at multiple fields.   Example:   In record One… Which is highest? Field a, field b, field c or field d Which is lowest? Field a, field b, field c or field d     Andrew Green