topic Select partial field in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-partial-field/m-p/6434496#M1411419 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Please let me know if there is a better way to select the record based on this criterial. I need to select records from a table but the first 2 position of that fiel is of certain value. For example,</P><P></P><P>SELECT DOCNR RFUND into table i_tab from FMGLFLEXA </P><P> where the first 2 positions of field RFUND = 'F1'. </P><P></P><P>Field RFUND is 10 char. I tried various scenarios to extract the record in the select statement but nothing work. Any idea?</P></BODY></HTML> Wed, 18 Nov 2009 20:52:40 GMT Former Member 2009-11-18T20:52:40Z Select partial field https://community.sap.com/t5/application-development-and-automation-discussions/select-partial-field/m-p/6434496#M1411419 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Please let me know if there is a better way to select the record based on this criterial. I need to select records from a table but the first 2 position of that fiel is of certain value. For example,</P><P></P><P>SELECT DOCNR RFUND into table i_tab from FMGLFLEXA </P><P> where the first 2 positions of field RFUND = 'F1'. </P><P></P><P>Field RFUND is 10 char. I tried various scenarios to extract the record in the select statement but nothing work. Any idea?</P></BODY></HTML> Wed, 18 Nov 2009 20:52:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-partial-field/m-p/6434496#M1411419 Former Member 2009-11-18T20:52:40Z Re: Select partial field https://community.sap.com/t5/application-development-and-automation-discussions/select-partial-field/m-p/6434497#M1411420 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Please do not ask basic questions. Press F1 on SELECT WHERE - post locked</SPAN></P><P></P><P>Rob</P></BODY></HTML> Wed, 18 Nov 2009 21:05:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-partial-field/m-p/6434497#M1411420 Former Member 2009-11-18T21:05:10Z