topic Re: where clause in Application Development and Automation Discussions

where clause

Former Member — Thu, 19 Jul 2007 04:50:02 GMT

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

Re: where clause

Former Member — Thu, 19 Jul 2007 04:53:06 GMT

like this

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

regards

Peram

Re: where clause

Former Member — Thu, 19 Jul 2007 04:56:16 GMT

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

Re: where clause

Former Member — Thu, 19 Jul 2007 04:59:29 GMT

HI,

see this code

tables:mara.

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

write:/ mara-matnr.

ENDSELECT.

rgds,

bharat.

Re: where clause

Former Member — Thu, 19 Jul 2007 04:59:44 GMT

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

Re: where clause

seshatalpasai_madala — Thu, 19 Jul 2007 05:07:48 GMT

Hi,

Use LIKE instead of IN.

Regards,

Sesh

Re: where clause

Former Member — Thu, 19 Jul 2007 05:17:45 GMT

hi,

give them in single quotations as

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

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

if helpful reward some points.

with regards,

Suresh.A

Re: where clause

Former Member — Thu, 19 Jul 2007 05:18:08 GMT

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.

Re: where clause

Former Member — Thu, 19 Jul 2007 05:41:08 GMT

thx for ur reply . the problem is solved.