topic Re: Selecting max value in character string in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/selecting-max-value-in-character-string/m-p/8258764#M1631868 <HTML><HEAD></HEAD><BODY><P>Hi Santhosh,</P><P></P><P>You need to use aggregate functions.</P><P></P><P>Select max(columname) from ztable into v_variable</P><P>group by (all keys).</P><P></P><P>All Keys - all primary keys should be listed.</P><P></P><P>HTH.</P><P></P><P>Best Regards,</P><P>Benedict</P></BODY></HTML> Wed, 21 Sep 2011 10:12:16 GMT Former Member 2011-09-21T10:12:16Z Selecting max value in character string https://community.sap.com/t5/application-development-and-automation-discussions/selecting-max-value-in-character-string/m-p/8258763#M1631867 <HTML><HEAD></HEAD><BODY><P>Hi Guru's,</P><P></P><P>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.</P><P></P><P>Ex : GATEEIXT_NO</P><P></P><P> NOD-1233</P><P> NOD-4566</P><P> 9011091000 </P><P> 9011091002 </P><P> If I write select query I have to select max value 9011091002 only . will any body please give solution for this.</P><P></P><P>Thanks,</P><P>Santhosh</P></BODY></HTML> Wed, 21 Sep 2011 10:00:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-max-value-in-character-string/m-p/8258763#M1631867 Former Member 2011-09-21T10:00:49Z Re: Selecting max value in character string https://community.sap.com/t5/application-development-and-automation-discussions/selecting-max-value-in-character-string/m-p/8258764#M1631868 <HTML><HEAD></HEAD><BODY><P>Hi Santhosh,</P><P></P><P>You need to use aggregate functions.</P><P></P><P>Select max(columname) from ztable into v_variable</P><P>group by (all keys).</P><P></P><P>All Keys - all primary keys should be listed.</P><P></P><P>HTH.</P><P></P><P>Best Regards,</P><P>Benedict</P></BODY></HTML> Wed, 21 Sep 2011 10:12:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-max-value-in-character-string/m-p/8258764#M1631868 Former Member 2011-09-21T10:12:16Z