select

[Former Member]

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

[Former Member]

hi,

in where condition use

select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 like 'C%'.

Rgds.,

subash

[Former Member]

>

> 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

[Former Member]

Hi,

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

Regards

Ramchander Rao.K

[Former Member]

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.

[abdul_hakim]

select kunnr name1 from kna1 into corresponding fields of table

it_kna1 where name1 LIKE 'C%'.

Cheers,

Hakim

[Former Member]

Hi,

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

Regards,

Rajat

[Former Member]

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.

[Former Member]

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

[Former Member]

Thanks everyone.

I managed to solved it experts.

WIth you all help..