topic Re: select - option in Application Development and Automation Discussions

select - option

Former Member — Wed, 20 Jun 2007 06:33:57 GMT

Hi Friends..

If i will give 5* in select statement i want to display all the records start from 5

if i will give 50* in select statement i want to display all the records start from 50

for that scenario what can i do..

can any one explain..

Thanks

Gowrishankar.

Re: select - option

Former Member — Wed, 20 Jun 2007 06:36:34 GMT

hi..

better u use <b>' 5%' and %50%</b> instead of 5* and 50*..

if u use 5% and 50% it will work properly..

Thanks

Ashu

Re: select - option

Former Member — Wed, 20 Jun 2007 06:38:07 GMT

Hi ,

Get the data in a variable, concatenate it with % and then use like statement in where clause in select statement.

concatenate '5' '%' into var.

Select * from table into itab where field like var.

Regards,

Sumit

Re: select - option

Former Member — Wed, 20 Jun 2007 06:38:18 GMT

Hi,

First case

WHERE Field LIKE '5%'.

Second case

WHERE Field LIKE '50%'.

Regards,

Ranjit Thakur.

<b>Please Mark The Helpful Answer.</b>

Re: select - option

Former Member — Wed, 20 Jun 2007 06:38:23 GMT

Use % symbol in where condition of the select statement

SELECT MATNR FROM MARA WHERE MATNR = '5%'.

IT WILL PICKUP ALL MATERIALS STARTING WITH 5..

Reward points for useful Answers

Regards

Anji

Re: select - option

Former Member — Wed, 20 Jun 2007 06:39:29 GMT

HI,

In the select statment you need to use % symbol to get al the records statrts from .....

SELECT * from TABLE INTO ITAB WHERE NAME like '5%'.

Regards

Sudheer

Re: select - option

Former Member — Wed, 20 Jun 2007 06:44:36 GMT

ok friends thanks for your reply..

one small correction.

If i will give the input in select-option at that time i want to disp[lay all the value.

if i give 5* or 5% means,i want the output like,,

all the numbers start from 5.