topic Re: select in Application Development and Automation Discussions

select

Former Member — Tue, 02 Dec 2008 08:48:20 GMT

Moderator message: please use a meaningful subject in future

Hi Experts,

I need to select all the customer name start with B alpahahet.

I have tried like this.

select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 = 'C%'.

But it is not working.

Please guide me.

Thank you in advanced.

Edited by: Matt on Dec 2, 2008 10:09 AM

Re: select

Former Member — Tue, 02 Dec 2008 08:50:24 GMT

hi,

in where condition use

select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 like 'C%'.

Rgds.,

subash

Re: select

Former Member — Tue, 02 Dec 2008 08:51:17 GMT


> Hi Experts,
> I need to select all the customer name start with B alpahahet.
> 
> I have tried like this.
> 
>       select kunnr name1 from kna1 into corresponding fields of table
>       it_kna1 where name1 = 'C%'.
> 
> But it is not working.
> Please guide me.
> 
> Thank you in advanced.

Hi Saravanan,

See the code below.

Select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 LIKE 'B%'.

Thanks

Nitesh

Re: select

Former Member — Tue, 02 Dec 2008 08:51:42 GMT

Hi,

when you use wildcards like % use LIKE addition in the where clause.

Regards

Ramchander Rao.K

Re: select

Former Member — Tue, 02 Dec 2008 08:52:51 GMT

I had the same problem and resolve it using RANGES table

I think you can use + and * to search but you can look in the help to confirm.

Re: select

abdul_hakim — Tue, 02 Dec 2008 08:53:40 GMT

select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 LIKE 'C%'.

Cheers,

Hakim

Re: select

Former Member — Tue, 02 Dec 2008 08:54:21 GMT

Hi,

you need to use 'LIKE' instead of '=' .

Regards,

Rajat

Re: select

Former Member — Tue, 02 Dec 2008 08:54:39 GMT

Hi,

We always need to use LIKE in context to wildcard pattern matching queries.

select kunnr name1 from kna1 into corresponding fields of table
it_kna1 where name1 LIKE 'C%'.

thanks.

Re: select

Former Member — Tue, 02 Dec 2008 08:56:00 GMT

Hi,

Check with LIKE addition..

or else.. .try offsetting as shown below..in the WHERE clause


select kunnr name1 from kna1 into corresponding fields of table
it_kna1 where name1+0(1) = 'B'

Cheers

Re: select

Former Member — Tue, 02 Dec 2008 08:56:47 GMT

Thanks everyone.

I managed to solved it experts.

WIth you all help..