Skip to Content
0
Former Member
Feb 08, 2009 at 02:19 AM

BDOC query parameter

20 Views

Hi all,

I have a Bdoc parameter syntax related question.

I want to set a query bdoc parameter as below where TERRID is a parameter and

i want to pass sql like ...

****SQL****

WHERE TABLE1.NTERRID LIKE 'TERRID%'

***BDOC QUERY***

WHERE TABLE1.NTERRID LIKE :TERRID

Now when this BDOC query is actually executes it puts % in front as well sql looks like below

WHERE TABLE1.NTERRID LIKE '%TERRID%'

how do i change my boc query parameter syntax to have % only at the end of the parameter and not in front.

Thanks in advance

Hetal