Hi,

I have a table with column char(20). The table has alphanumeric data. When i select max(column) on that table, its giving wrong data. See below more details:

Data:
db2 "select * from EPSAR_WKLY_DET_ UV"
R33337A00A3E
R33337883E70

select max(RETAIN_USER _ID) from EPSAR_WKLY_DET_ UV" =
R33337A00A3E

Instead of R33337883E70 which is bigger, its displaying...