topic How to select in table using *? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-select-in-table-using/m-p/6750167#M1460001 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I need to retrieve all entries from table MARA where the material number starts with 1000. I know that in SE16N, we can just input 1000* in matnr field, but how do we do this via select statement in program?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 16 Apr 2010 14:07:11 GMT Former Member 2010-04-16T14:07:11Z How to select in table using *? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-select-in-table-using/m-p/6750167#M1460001 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I need to retrieve all entries from table MARA where the material number starts with 1000. I know that in SE16N, we can just input 1000* in matnr field, but how do we do this via select statement in program?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 16 Apr 2010 14:07:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-select-in-table-using/m-p/6750167#M1460001 Former Member 2010-04-16T14:07:11Z Re: How to select in table using *? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-select-in-table-using/m-p/6750168#M1460002 <HTML><HEAD></HEAD><BODY><P>You can find out yourself with a little research, please do so next time before posting.</P><P>Thread locked.</P><P>Thomas</P></BODY></HTML> Fri, 16 Apr 2010 14:09:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-select-in-table-using/m-p/6750168#M1460002 ThomasZloch 2010-04-16T14:09:06Z