topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 24 Mar 2008 21:27:29 GMT

Hi All!

My requiremnt is to select the entries for company from a table where the company code value starts from 2* only there are many other company code values in that table apart from 2000 like1000 also.

eg: I need to select all the companies for the company codes starting from 2000 only, like 2000,2001,2002.....

pls advice...

Re: select statement

Former Member — Mon, 24 Mar 2008 21:34:57 GMT

Try with the below select statement.

SELECT * FROM T001

INTO TABLE ITAB

WHERE BUKRS LIKE '2%'.

Thanks,

Srinivas

Re: select statement

Former Member — Mon, 24 Mar 2008 21:57:32 GMT

thanks a lot...,