topic Re: substring in select statement in Application Development and Automation Discussions

substring in select statement

Former Member — Wed, 07 Feb 2007 09:21:33 GMT

hi all,

may i know how to have substring in select? i got the error when i define so.

pls advise.

thanks

SELECT SINGLE * FROM mara

WHERE matnr0(1) = fieldvalue0(1).

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:23:19 GMT

Hi El,

You cannot do that way.

Do this way:

concatenate fieldvalue+0(1) '%' into v_str.

select single * from mara

where matnr like v_str.

Regards,

Ravi

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:24:29 GMT

you cannot use substrings to the left of the WHERE condition , only right hand side you can use substrings

May be you have to select data into one internal table and then use offsets

loop at itab.

if itab-matnr0(1) = fieldvalue0(1).

endloop.

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:25:15 GMT

hi ,

dont use it in that way

first concatenate the field in an variable

then use that variable in u r select query

cheers

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:37:58 GMT

el,

data : v_var(1),

v_per value '%',

v_final(2).

v_var = fieldvalue+0(1).

concatenate v_var v_per into v_final.

SELECT SINGLE * FROM mara

WHERE matnr like v_var.

Pls. mark if useful

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:42:54 GMT

Hi,

You can use offset only at the right side, if the left side value is less tahn the right side value you can use this as

WHERE matnr = name+0(10).

Hope you are clear. Please reward and close the thread if ur problem got solved else get back with queries.

Re: substring in select statement

Former Member — Wed, 07 Feb 2007 09:44:26 GMT

thanks