Select query problem

[Former Member]

Hi guys,

In my select query, i want to select data where BSID-ZUONR field starts with '137'. can anyone tell me how can i select like that in my select query?

here is my select query

SELECT KUNNR ZUONR BUDAT UMSKZ GJAHR XBLNR BELNR BLART DMBTR SHKZG

FROM BSID INTO TABLE IT_BSID_ONE

WHERE BUKRS IN S_BUKRS

AND UMSKZ IN ('' , 'A')

AND BUDAT =< P_BUDAT.

Thanks.

[sjeevan]

AND ZUONR like '137%'

[Former Member]

Thanks alot man

[Former Member]

HI,

Make sure you use the primary keys / indexes carefully as this is a very large table.

Danish.