select statement for like

[Former Member]

Hi,

I would like to create structure for the following statement,

select * from salary_update where emp_no like ?.

How can I implement this?. Thanks-in-advance for help.

p.s: Points will be guarantily rewarded.

Thanks,

Sunita.

[MichalKrawczyk · Accepted solution]

Hi,

you can use compareOperation = LIKE

<key1>

<col4 compareOperation=”LIKE”>val%</col4>

</key1>

for more have a look at:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[Former Member]

hi Michal and Moorthy,

Thanks for the help.

/Sunita.

[moorthy]

Hi Sunita,

Just go thru this thread- may take sometime to read

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Hope this helps,

regards,

Moorthy