[eclipselink-users] Best way to support case insensitive alphanumeric so

[vaidya nathan <vaidyaatdst@xxxxxxxxx>]

Hi,

What is the best way to support case insensitive alphanumeric sorting using jpa2 and eclipselink ? An example of what i would like to achieve is to sort on something similiar to the canada zips which could be alphanumeric..

We are using Eclipselinks ReadAllQuery and _expression_ language to build our queries and the queries that we have so far is like this..

SELECT * FROM
(SELECT a.*, ROWNUM rnum  FROM
(SELECT DISTINCT t1.ID AS a1,<colname>
  FROM <Table>  ORDER BY t0.<colname> ASC) a WHERE ROWNUM <= ?) WHERE rnum > ?

)a

Thx