https://community.sap.com/t5/application-development-and-automation-discussions/material-number-suffix/m-p/4298709#M1025064 <HTML><HEAD></HEAD><BODY><P>You can use LIKE option in where condition.</P><P></P><PRE><CODE>where matnr like '100678%'.</CODE></PRE><P></P></BODY></HTML> Wed, 13 Aug 2008 17:23:59 GMT Former Member 2008-08-13T17:23:59Z https://community.sap.com/t5/application-development-and-automation-discussions/material-number-suffix/m-p/4298708#M1025063 <HTML><HEAD></HEAD><BODY><P>hi gurus ,</P><P></P><P>i have a join which fetches material number but i also want those material numbers with suffixes attached to it e.g thersa </P><P>material 100678 ,100678T ,100678UYT ,</P><P>my select query should return all three material</P><P>so what should be the where condition for my join</P></BODY></HTML> Wed, 13 Aug 2008 17:16:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-number-suffix/m-p/4298708#M1025063 Former Member 2008-08-13T17:16:37Z https://community.sap.com/t5/application-development-and-automation-discussions/material-number-suffix/m-p/4298709#M1025064 <HTML><HEAD></HEAD><BODY><P>You can use LIKE option in where condition.</P><P></P><PRE><CODE>where matnr like '100678%'.</CODE></PRE><P></P></BODY></HTML> Wed, 13 Aug 2008 17:23:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/material-number-suffix/m-p/4298709#M1025064 Former Member 2008-08-13T17:23:59Z