08-13-2008 6:16 PM
hi gurus ,
i have a join which fetches material number but i also want those material numbers with suffixes attached to it e.g thersa
material 100678 ,100678T ,100678UYT ,
my select query should return all three material
so what should be the where condition for my join
08-13-2008 6:23 PM
You can use LIKE option in where condition.
where matnr like '100678%'.