Lesser of two values in list

2009-12-17 Thread Cantwell, Bryan
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?

Re: Lesser of two values in list

2009-12-17 Thread Peter Brawley
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