I'm using Postgres 8 and Criteria queries. I am trying to order by a column, but Postgres sorts it so that upper case matches are plaaced before lower-cased ones. When doing a regular sql query, handling this is easy, as all you do is 'order by upper(x.y) asc'. I don't know how to do it using criteria queries, though.

Is there a way to do an upper() on addOrder statements? Or is there a better way to go about doing a case-insensitive order by, using criteria queries?

Thanks.