topic Re: DYNAMIC VARIABLE IN SELECT QUERY in Application Development and Automation Discussions

DYNAMIC VARIABLE IN SELECT QUERY

Former Member — Wed, 22 Aug 2007 09:43:52 GMT

hi all,

i m selecting a belnr from one table and want to fire another query on different table wherein this belnr falls somewhere in middle of the whole field.

eg: wa-belnr = 4000

select * from cdhdr where

objectclass = '%wa-belnr%.

i want to select records which contains this belnr.

but %wa-belnr% doesnt work.

pls suggest if theres any solution.

Re: DYNAMIC VARIABLE IN SELECT QUERY

Former Member — Wed, 22 Aug 2007 09:46:11 GMT

You need to do this

concatenate '%'

wa_belnr

'%'

into w_field

then use w_field on your select.

Re: DYNAMIC VARIABLE IN SELECT QUERY

Former Member — Wed, 22 Aug 2007 09:48:53 GMT

for ex if belnr is the 10 characters in middle of field starting from 6th character

u can use

select * from cdhdr where objectclass = field+5(10).

Re: DYNAMIC VARIABLE IN SELECT QUERY

seshatalpasai_madala — Wed, 22 Aug 2007 09:51:57 GMT

Hi,

select * from cdhdr where

objectclass = '%wa-belnr%.

In the above query use LIKE instead of '='.

Also instead of %wa-belnr% Use like this

<b>DATA: str type string.

concatenate '%' wa_belnr '%' into str.

select * from cdhdr where

objectclass LIKE str.</b>

Regards,

Sesh

Re: DYNAMIC VARIABLE IN SELECT QUERY

dev_parbutteea — Wed, 22 Aug 2007 09:59:15 GMT

Hi,

use

concatenate '%'

wa_belnr

'%'

into lv_BELNR

select * from cdhdr where

objectclass LIKE lv_BELNR

regards