topic Re: Regarding Data Base Select Query in Application Development and Automation Discussions

Regarding Data Base Select Query

Former Member — Fri, 21 Sep 2007 09:35:52 GMT

Hi All,

I want to extract the data from data base into my internal table

by not giving the exact value but the pattern.

Ex) I want to select the vendor starting with patter '12*'

from LFA table in my internal table.

Which select Query I should use for getting the

Vendor No. starting with pattern '12*' ?.

Points will be rewaded.

Thanks in Advance.

With Regards

Jitendra Gujarathi.

Former Member — Fri, 21 Sep 2007 09:38:57 GMT

select fld1 fld2 from lfa1
                 into table itab
                 where  lfnr like '12%'

Former Member — Fri, 21 Sep 2007 09:39:30 GMT

select lifnr into table itab from lfa1 where <b>lifnr like '12%'.</b>

it will fetch the record which starts with 12 only

you may use lifnr like '%12%' also it will fetch the record which contain any 12 in it.

be careful about leading zeroes lifnr may contain leading 0.

regards

shiba dutta

Former Member — Fri, 21 Sep 2007 09:41:21 GMT

Hi jitendra,

1. simple

select * from lfa1

into table lfa1

where lifnr like '12%'.

regards,

amit m .

Former Member — Fri, 21 Sep 2007 09:42:59 GMT

<b>CONCATENATE w_lifnr '%' INTO w_lifnr.

select lifnr from lfa1 where lifnr like w_lifnr.</b>

Regards,

Pavan