select statement

[Former Member]

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...

[Former Member]

Try with the below select statement.

SELECT * FROM T001

INTO TABLE ITAB

WHERE BUKRS LIKE '2%'.

Thanks,

Srinivas

[Former Member]

thanks a lot...,