Selecting max value in character string

[Former Member]

Hi Guru's,

I am fetching data from ztable . In this table I have to select GATEEXIT_NO which is dat type charecter . For this I have both numeric values and character value's eixts in table . In this I have to select max value.

Ex : GATEEIXT_NO

NOD-1233

NOD-4566

9011091000

9011091002

If I write select query I have to select max value 9011091002 only . will any body please give solution for this.

Thanks,

Santhosh

[Former Member]

Hi Santhosh,

You need to use aggregate functions.

Select max(columname) from ztable into v_variable

group by (all keys).

All Keys - all primary keys should be listed.

HTH.

Best Regards,

Benedict