RE: [CFTALKTor] High and low's

[Steve Budan]

in most db's you can do if statements and case blocks in your select. Syntax will vary, but depends on your definition of simple. It would not be simple for me.   -steve     -----Original Message----- From: Andrew Green [mailto:[EMAIL PROTECTED]] 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