where clause

[Former Member]

hi

in select query i am using where condition.

in my selection i would want to display data that start with Z and Y.

i have used like this.. where NAME IN (Z%,Y%).

but it's not working..

give me some other solution to overcome this...

plz reply me..

[Former Member]

Hi,

use select command like this :

SELECT ernam

FROM ekko

INTO corresponding fields of table it_test

WHERE ernam like 'Y%'

or ernam like 'Z%'.

Entry in Capital letters only.

Reward points, if helpful,

Sandeep Kaushik

[Former Member]

like this

NAME IN ('Z%','Y%').

regards

Peram

[Former Member]

Hi

Try with Z% and Y% in where clause

<b>select matnr into v_matnr from mara where matnr LIKE 'Z%' or matnr LIKE 'Y%'.</b>

Other wise fetch the data completely into itab then loop it

loop at itab.

if ( itab-field0(1) ne 'Z' or itab-field0(1) ne 'Y' )

delete Itab index sy-tabix.

endif.

Endloop.

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

HI,

see this code

tables:mara.

select * from mara where matnr in ('z%','y%').

write:/ mara-matnr.

ENDSELECT.

rgds,

bharat.

[Former Member]

Hi,

use select command like this :

SELECT ernam

FROM ekko

INTO corresponding fields of table it_test

WHERE ernam like 'Y%'

or ernam like 'Z%'.

Entry in Capital letters only.

Reward points, if helpful,

Sandeep Kaushik

[seshatalpasai_madala]

Hi,

Use LIKE instead of IN.

Regards,

Sesh

[Former Member]

hi,

give them in single quotations as

where NAME IN ('Z%','Y%')

or

name like 'Z%' or like 'Y%'.

if helpful reward some points.

with regards,

Suresh.A

[Former Member]

Hi Limat,

view this code and use like instead of IN.

DATA: T_SFLIGHT LIKE SFLIGHT OCCURS 0 WITH HEADER LINE.

SELECT * FROM SFLIGHT INTO TABLE T_SFLIGHT WHERE CARRID = 'AZ' AND

CONNID IN ('0555', '0790') AND FLDATE LIKE '2004%'.

LOOP AT T_SFLIGHT.

WRITE: /,T_SFLIGHT-CARRID,T_SFLIGHT-CONNID.

ENDLOOP.

If useful rewrad me with points.

Thanks.

Sanket.

[Former Member]

hi

thx for ur reply . the problem is solved.