Hello every body have a problem in using LIKE statement. I have written a BAPI to get the items according to the search criteria. Please advice, how can i pass my text to the select statement. At present i am passing the description like PIPE% from the front end.
SELECT * FROM TABLE WHERE DESCRIPTION LIKE DESCRIPTION.
I don't want to pass the description like PIPE% and the percentage symbol should be taken care in the back end.