Re: remove dups
min() works just fine with char/varchar. Always has.
Jay Buckler
"Mark D. Stock" <mdstock@mydas.freeserve.co.uk> wrote in message
news:8j8kps$75b$1@news.xmission.com...
>
> pauleccleston@my-deja.com wrote:
> >
> > SELECT id, min(text) from table group by id>
> Nice thought, but MIN requires (or at least always used to require) a
> numeric argument.
>
> Cheers,
> --
> Mark.
>
> +----------------------------------------------------------+-----------+
> | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /|
> | http://www.informix.com http://www.informixhandbook.com |///// /
file://|
> | http://www.iiug.org +-----------------------------------+//// / ///|
> | |This email will self-destruct in |/// / ////|
> | |10 sec. If you received this email |// / /////|
> | |in error, sorry about the mess. |/ ////////|
> +----------------------+-----------------------------------+-----------+