Subject Re: The greater/lesser of a number of values
Author ai_no_kareshi
> No. Version 2.1 will introduce these functions, maxvalue and minvalue.

That certainly is good news. :)

> You can solve this by writing and UDF function that will take 3
arguments
> and return min or max of them

I've never written a UDF function, but I suppose I could. It seems
like a bit of a waste, though, if Version 2.1 is going to include such
functions anyway.

> What you should really do is normalize your tables by getting rid of
> repeating groups and put ratings in detail table.

I appreciate your advice. While these three ratings may seem very
similar in my example, though, in the actual database they are
actually three very distinct fields that are treated very differently
all over. Putting them in a separate table would significantly
complicate a great number of other queries.