Hi all, i have some problem with the select expert, or the odbc sort, or whatelse.

E.g.

I have in my db table (as400 ebcdic) these records (in this order):

AA
AAAA11
AAAA12
AAAA12C
AA005
AA1

I want to display all the records with my code (char 15) less than
 "AA1" so my record selection formula is {myfile.mycode} < "AA1"

but the result of the query is

AA
AA005

Why?

I have tried with excel using the same ODBC but the result was correct, just in my Crystal XI the result is not what i want.

As anyone suggestions?
Thanks

Corrado

Thanks for the answer but maybe my question is not explained very well.

If i have a table with records ordered like this:
A
AA
AB
AC
B
BA
BB
BC
C
CA
CB
CC
.. and so on.

I want to select the records where the value is greater than B and less than C.  I write a select * from table where code > "B" and code < "C"  and ther results are all the codes between B and C.

The problem is when crystal do the select records.

These are the records ordered not the records sequence in the file.

AA
AAAA11
AAAA12
AAAA12C
AA005
AA1

So if my select is select * from table where code < "AA1"  AAAA12should be a selected record.






Edited by besando - 24 Jan 2013 at 6:25am