Group by - Case insensitivity

Off the top of my head, I can think of a couple of ways.

select lower(name), count(*) from customer group by lower(name);

or

select min(name), count(*) from customer group by lower(name);

The second one works if you still want some semblance of the original
casing of the field.

On Jun 28, 2004, at 9:15 AM, UMPA Development wrote:

In the last exciting episode, dev@umpa-us.com (UMPA Development) wrote:

Is it possible to setup a group by to be case insensitive and if so how?

Well, you could presumably canonicalize the field to one case or the
other, thereby forcing the issue. That's not _exactly_ the same thing
as "case insensitivity," but it may be close enough.
--
output = reverse("gro.mca" "@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/x.html
Are you pondering what I'm pondering?

On Mon, 2004-06-28 at 09:15, UMPA Development wrote:

Hello all!

Is it possible to setup a group by to be case insensitive and if so how?

group by lower(field)