select from jcds all status begin with E

[Former Member]

Hello Experts,

i need to select all rows that the status begin with E.

how can i do that?

thanks,

Michal.

[kesavadas_thekkillath]

Example:

SELECT objnr stat udate utime INTO TABLE it_time[] FROM jcds FOR ALL ENTRIES IN it_aufk[]

WHERE objnr EQ it_aufk-objnr AND ( stat LIKE 'E%' ).

[Former Member]

Hi michal

select * from <table > into table <Itab> where status like 'E%'.

<table> - data base table.

<itab> - Internal table which is declared in program.

Regards,

Sateesh

[Former Member]

Use WILD Card %.

[Former Member]

Hi Michal

Use the wild card character '%' in the where clause.

Select * from DBTABLE

INTO TABLE itab

where Stat LIKE 'E%'.

Hope this helps.

Harsh

Edited by: Harsh Talesra on Jun 8, 2009 1:48 PM