From: Peter Brawley
Date: December 17 2009 7:24pm
Subject: Re: Lesser of two values in list
List-Archive: http://lists.mysql.com/mysql/219835
Message-Id: <4B2A855F.8080702@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040001090504090004080402"

--------------040001090504090004080402
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >I need to find the lesser of two values provided in a list

LEAST().

PB
http://www.artfulsoftware.com

-----

Cantwell, Bryan wrote:
> I need to find the lesser of two values provided in a list. I know I can do it with a couple of IF's in a function, but I'd really like to know if there is already a function that I can use.
>
> min(12,3,1,4)  of course doesnt work, but is there some other math function I am overlooking in MySql?
>   
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com 
> Version: 8.5.427 / Virus Database: 270.14.111/2570 - Release Date: 12/17/09 08:30:00
>
>   

--------------040001090504090004080402--