topic Re: wild card in select statement in Application Development and Automation Discussions

wild card in select statement

Former Member — Thu, 12 Apr 2007 11:42:25 GMT

hi,

I want to select following feilds from KNA1 KUNNR

NAME1

NAME2

LAND1

ORT01

PSTLZ

REGIO

STRAS

TELF1

ADRNR

ERNAM

ERDAT

based on the following condition below:

Wildcard on customer name:

a. Starts with

b. Contains

Please send me a sample code of how to select the customer name based on the above conditions

rewards guaranteed.

neha

Re: wild card in select statement

Former Member — Thu, 12 Apr 2007 11:43:59 GMT

Hi..

select

KUNNR

NAME1

NAME2

LAND1

ORT01

PSTLZ

REGIO

STRAS

TELF1

ADRNR

ERNAM

ERDAT

from KNA1

INTO TABLE ITAB

WHERE NAME1 LIKE 'SAI%' . "<-- Starts with SAI

WHERE NAME1 LIKE '%SAI%' . "<--Contains SAI

Here SAI is case sensitive .. if u give in Capital letters then it will search for capital letters onli.

reward if it helps u..

sai ramesh

Re: wild card in select statement

Former Member — Thu, 12 Apr 2007 11:46:05 GMT

Select

NAME1

NAME2

LAND1

ORT01

PSTLZ

REGIO

STRAS

TELF1

ADRNR

ERNAM

ERDAT

from KNA1

INTO TABLE ITAB

WHERE NAME1 LIKE 'A%' .

Hope this helps

Regds

Seema

Re: wild card in select statement

Former Member — Thu, 12 Apr 2007 11:53:12 GMT

Hi..

1.% for a sequence of any characters (including spaces).

2._ for a single character.

select

KUNNR

NAME1

NAME2

LAND1

ORT01

PSTLZ

REGIO

STRAS

TELF1

ADRNR

ERNAM

ERDAT

from KNA1

into itab

where NAME1 like 'R%' . "or

for second one,

lets say ur string is 'ram'.

concatenate '%' 'ram' '%' into w_string.

select ....

from kna1

into itab

where name1 like w_string.

Re: wild card in select statement

Former Member — Thu, 12 Apr 2007 12:57:30 GMT

Hai,

Here is the sample code:

SELECT

KUNNR

NAME1

NAME2

LAND1

ORT01

PSTLZ

REGIO

STRAS

TELF1

ADRNR

ERNAM

ERDAT

FROM KNA1

WHERE CUSTOMER NO LIKE 'ABC%XYZ%'.

It means:

Customer no Starts with

ABC and Contains the string XYZ

% wildcard means zero or nore any characters.

Possible Customer numbers are:

ABCppppXYZqqq

ABCXYZqqq

ABCXYZ

Hope you got idea.

Reward points if it helps you.

Regds,

Rama chary.Pammi

Re: wild card in select statement

Former Member — Thu, 12 Apr 2007 13:05:48 GMT

Hi neha,

Now we shall look at another way.

All the above ways will work.

ranges: s_name1 for kna1-name1.

* For starts with

s_NAME1-sign = 'I'.

s_name1-option = 'CP'.

concatenate s_name1-low '*' into s_name1-low.

append s_name1.

select * from kane1 into table

where name1 in s_name1.

* For Contains

s_NAME1-sign = 'I'.

s_name1-option = 'CP'.

concatenate '" s_name1-low '' into s_name1-low.

append s_name1.

select * from kane1 into table

where name1 in s_name1.

Regards,

Ravi