Re: String functions for use in GROUP clause?

2003-10-10 Thread Egor Egorov
David Garamond <[EMAIL PROTECTED]> wrote: > We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all > numeric functions. Is it possible to use string functions as well? I > know MIN() & MAX() can be asciibetical for string fields, but wouldn't > this be very handy/practical? > > SELE

String functions for use in GROUP clause?

2003-10-10 Thread David Garamond
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all numeric functions. Is it possible to use string functions as well? I know MIN() & MAX() can be asciibetical for string fields, but wouldn't this be very handy/practical? SELECT division, G_CONCAT(", ",first_name) as nicks,